Error help

[JonathanB2]

Hello,

I have a feeling this can be fixed with an IFERROR trick, but I couldn't solve the solution via google (or searching these forums) so here I am.

I have a formula =E4*1.05/((D4*40*5.1))

The problem is, if there's nothing in the D cell then it errors out. However, I don't want to set it to a zero or anything....I'd actually like to remove that part of the equation if there's nothing in the D cell. For example, there's an error now because there's nothing in D4...but if you alter the formula to =E4*1.05/((40*5.1)) then it provides what I believe is correct. Does this make sense? Is there any way to say if there's an error ignore D4, or else use the new forumula?

Thanks in advance!

J

[sktneer]

May be this.......

Please Login or Register  to view this content.

[bebo021999]

Maybe:
=E4*1.05/((IF(D4=0,1,D4)*40*5.1))

[JonathanB2]

They both worked, thanks so much. I'll mark this as solved

[sktneer]

Glad to help you. Thanks for the feedback.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This another way to say thanks to them.