Hello Everyone,
This formula is in cell Z8:
=IF(ROUND(AA8,2)<>ROUND(Y8,2),"O","X")
And this formula is in cell AB8:
=IF(Y8=0,0,AA8-Y8)
Cell Y8 is just manually input by the user.
I want the formula in cell Z8 to only display an O if the result it produces is either $1 (or more) higher or lower that cell AB8.
For example if the figure in cell Y8 is $120.00 and the figure in cell AA8 is $120.56 then cell Z8 will display an X because the difference is not $1 or more.
If however Y8 is $120.00 and the figure in cell AA8 is $122.00 then cell Z8 will display an O because the difference is $1 or more.
I hope this makes sense! It does to me but Excel does not! I need to do a crash course in Excel I think!
Thank you very much in advance for any help,
Margate
Bookmarks