DIV Error in % Formula ...

[Russ At Index]

Morning ,

Would someone kindly put me out of my misery and point me in the right direction
to have the formula below NOT report any DIV ERRORS .

=1-(E2/C2)

Thanks ,

Russ.

 

[Fluff]

How about

=IF(OR(C2=0,C2=""),"",1-(E2/C2))

 

[Alex Blakenburg]

Alternatively you could use:

=IFERROR(1-(E2/C2),"Alternate_Value_Or_Calculation")

 

[Russ At Index]

Fluff , Alex ....

We have joint winners !!

Many thanks for helping me out .... it was driving me ever so slightly mad !

Have a good day both

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Russ At Index]

Hi Fluff , Alex ...
Sorry to reignite the thread , but i have another DIV issued i hope you can assist with .
=(MAX(D5*AW5*(AG5/100)*(MIN(1,AW5/AV5)),N5))/(D5*AW5)
The cells all refer to numbers.
Returns DIV error , but what i would really like is " - " .
Driving me mad this one !!!

Thanks Guys ,

Russ.

 

[Alex Blakenburg]

Fluff's solution was addressing the root cause of the issue. Using IFError effectively ignores the root cause and just replaces the error with an alternate return value.
So if you are ok with that then this should do what you want.

=Iferror((MAX(D5*AW5*(AG5/100)*(MIN(1,AW5/AV5)),N5))/(D5*AW5)," - ")

If not you need to address handling AV5, D5, AW5 being blank or 0.

 

[Russ At Index]

Morning Alex ,

Apologies for the delay in the response .

Worked a treat ..... had to play around a little with the base spreadsheet ( it is not mine !! ) , but my dilemma is resolved !!

Many thanks both , appreciate your assistance as always

Stay safe ,

Russ.

 

[Alex Blakenburg]

Thanks for following up, glad we could help.