You must have a text value in G12 or F12

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jetheat " wrote in message
...
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 leave
this cell Blank, otherwise do this formula
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 is
entered into the cells defined in the formula?


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