# DIV Error in % Formula ...

#### Russ At Index

##### Well-known Member
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.

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Excel Formula:
``=IF(OR(C2=0,C2=""),"",1-(E2/C2))``

Alternatively you could use:
Excel Formula:
``=IFERROR(1-(E2/C2),"Alternate_Value_Or_Calculation")``

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

Glad we could help & thanks for the feedback.

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.

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.
Excel Formula:
``=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.

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.

Thanks for following up, glad we could help.

Replies
3
Views
120
Replies
5
Views
199
Replies
5
Views
376
Replies
2
Views
170
Replies
2
Views
97

1,206,921
Messages
6,075,584
Members
446,147
Latest member
homedecortips

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back