So I have the following formula
=IF(K9<D7,"Unacceptable","Acceptable")
Both values are the same (£592,543.21) but the formula still displays the result 'Unacceptable'.
I think this might be down to the 'accounting formatting'. The general values are - D7 = 592543.21 & K9 = 592543.2099. Using these values, the formula is correctly displaying the 'unacceptable' result.
How can I display as ' Accounting formatting - £' but have it so that the figures as seen as equal and thus display as 'acceptable' ?
=IF(K9<D7,"Unacceptable","Acceptable")
Both values are the same (£592,543.21) but the formula still displays the result 'Unacceptable'.
I think this might be down to the 'accounting formatting'. The general values are - D7 = 592543.21 & K9 = 592543.2099. Using these values, the formula is correctly displaying the 'unacceptable' result.
How can I display as ' Accounting formatting - £' but have it so that the figures as seen as equal and thus display as 'acceptable' ?