View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 509
Default IF Formula Error

I seem to be incurring an error when trying to create an IF formula.

The formula is as follows:
=IF(D1=0,E1,D10.01,B30*D1)

Basically, the argument is that if I produce my quote in a foreign currency,
the cell where the price appears looks to reference D1 to see if there is a
foreign currency. If it says 0, there's not - if it is a value greater than
0.01 there is, then it has to take the cell where the price is, in this case
B30 and multiply it by the value in D1

What am I doing wrong??