Forum Discussion
test calculated numbers against actual numbers for TRUE
I wrote a simple formula to seek whether a deposited amount (an actual number entered by keyboard into a cell) was equal to a calculated number, as in this formula, written in cell H9: = IF(C4+B7=J9,...
mskulicz999matthew57 Probably a rounding issue. Display the numbers concerned (i.e. J9 and C4+B7) with 15 decimals and see if they are the same all the way through. If not, try using
=IF(ROUND(C4+B7,2)=J9,1,2)