Hi folks,
I have this formula:
=IF($D$6=$D$26,"n/a",COUNTIF($B$9:$V$18,">"&D7))
I want to convert this so it ROUNDS all cells in the range $B$9:$V$18 before it checks if it is > D7.
The values can be any precision between 1 and 6 places of decimals which is dictated by the value in G7.
So...