Ben
All of the attached formulae work in their respective ways.
Maybe you could post a sample of what you actually want and let us re-assess
Also, check to formatting of your cells to make sure they are all formatted
as numbers.


HTH
Michael M

"Ben" wrote:

It still wont multiply the value in B30 by the value in D1 when there is a
value in D1!

"joeu2004" wrote:

On May 6, 2:26 pm, 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)

Perhaps this is what you were trying to write:

=if(or(D1=0,D1<=0.01), E1, B30*D1)

But note that that can be simplied to just:

=if(D1<=0.01, E1, B30*D1)