Thread: Formula doesn't compute. Can you figure it out?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jetheat[_6_] Jetheat[_6_] is offline
external usenet poster
  
Posts: 1
Default Formula doesn't compute. Can you figure it out?
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 formul
[IF(E18="B",G18-F18,F18-G18)] = 0 and then the formula tries to us
that 0 for division, so its trying to do 0/100 or 0/1 which is probabl
why its returning the error.

How do I chage the formula to correct this?

Thank

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

Reply With QuoteReply With Quote