Error (again), IF needed

[JonathanB2]

Hello,

I recently posted a similar question but since this is slightly different, and I like following the rules, I started a new thread for this question.

I have a formula =E1*1.02/((D1*22))

However, when D1 is empty it produces an error (as it should). Unfortunately, when D1 is empty, I want it to use the formula without the D cell. For example, if D1 is empty it would read =E1*1.02/22, or something like that (removing the D cell from the equation).

I tried doing =IF(D1="",E1*1.01/22), E1*1.02/((D1*22)) and it's not working (value error). What am I doing wrong?

I appreciate your help in advance!

[shg]

=1.02 * e1 / 22 / if(n(d1), d1, 1)

or

=1.02 * e1 / 22 * iferror(1/d1, 1)

[JonathanB2]

Excellent! Thanks shg, I really appreciate it.

[shg]

You're welcome.