I've input the following formula
=IF(D19-SUM(D13+D14+F13+F14)>199999.999,"NO",IF(D19-SUM(D13+D14+F13+F14)>199999.999,"YES"))
in other words, below this value the cell says NO, above it says YES.
Unfortunately when "D19-SUM(D13+D14+F13+F14" = exactly 200,000.00 (must be accurate to 2 decimal its) then the result is showing "FALSE" and it should read "YES"
The weird thing is until "D19-SUM(D13+D14+F13+F14" reaches a value of 200,014.00 does the result show correctly as "YES".
(Further Information - cell D19 is a sum of 2 other cells)
Secondly, Is it possible to "grey out" some further cells below (in another part of the document) when the above IF statement results "NO"?
Thanks
Bookmarks