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)