I have this formula at the end of a row in column J.

=IF(AND(E12<"B",E12<"S"),"",IF(E12="B",G12-F12,F12-G12)/IF(C12="JPY",100,1)

It says that if Cell E12 is anything other than "B" or "S" than leav
this cell Blank, otherwise do this formul
IF(E12="B",G12-F12,F12-G12)/IF(C12="JPY",100,1)

The cell is not blank and it contains #VALUE instead.

How do I get rid of #VALUE and leave the cell blank unless data i
entered into the cells defined in the formula

--
Message posted from http://www.ExcelForum.com