0/100 and 0/1 is 0, not #VALUE.

--

HTH

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

"Jetheat " wrote in message
...
Ok, I figured out what it is but don't know how to correct it.

The full formula is


=IF(AND(E18<"B",E18<"S"),"",IF(E18="B",G18-F18,F18-G18))/IF(D18="JPY",100,
1)

If the row is empty, the middle part of the formula
[IF(E18="B",G18-F18,F18-G18)] = 0 and then the formula tries to use
that 0 for division, so its trying to do 0/100 or 0/1 which is probably
why its returning the error.

How do I chage the formula to correct this?

Thanks


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