Hi,
I have a peculiar problem. I display TRUE or FALSE in a cell and is based on the below formula.
=(IF(ISNUMBER($B66),($AK66=($P66-$V66+$AA66+$AB66-$AF66)),""))
But the value displayed is FALSE. The value in AK66 is equal to 650.38 and the sum of ($P66-$V66+$AA66+$AB66-$AF66) is also equal to 650.38.
The same formula is copied to the entire column and it shows TRUE for other cells and is as expected. I tried with several values.
Can anybody help me out pls.
Bookmarks