Your formula is written so that if D10.01, the result is E1, not B30*D1.

Do you want:

=IF(D10.01,B30*D1,E1)

???


In article ,
Ben wrote:

Hi Michael,
I copied that in and although it doesn't come up with the forumla error,
when there is a value in cell D1 that's above 0.01, it's not carrying out the
B30*D1.
Any suggestions? Maybe it needs a different forumla to IF?
Cheers,
Ben

"Michael M" wrote:

Hi ben
Try
=IF(D1=0,E1,IF(D10.01,E1,B30*D1))

HTH
Michael M

"Ben" wrote:

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??