sparky2205
Active Member
- Joined
- Feb 6, 2013
- Messages
- 480
- Office Version
- 365
- 2016
- Platform
- Windows
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 something like:
=IF($D$6=$D$26,"n/a",COUNTIF(ROUND($B$9,$G$7):ROUND($V$18,$G$7),">"&D7))
But this produces an error, error in formula not result, so I'm assuming that syntax is just wrong.
Thanks.
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 something like:
=IF($D$6=$D$26,"n/a",COUNTIF(ROUND($B$9,$G$7):ROUND($V$18,$G$7),">"&D7))
But this produces an error, error in formula not result, so I'm assuming that syntax is just wrong.
Thanks.