On my Totals tab/sheet a cell has the following formula;
=IF(ISERR(Educational!B6/Educational!C9),0,Educational!B6/Educational!C9)
It produces a value of €œ0€� when there are not any values in the cells on the
€œEducational€� tab/sheet. The formula currently works as desired.

I have two other Occupancy use groups that have min and max parts in their
formulas that I need to have the answer be €œ0€� on my Totals sheet when their
cell value from the other tab/sheet are zero or nothing.

I know it has to do something with =IF(ISERR in the formula in addition to
the ,0, but I have not been able to correct the formula to make it work.

Here is Cell C36s formula prior to the IF scenario.
=SUM(MIN(Business!B6,50)/Business!B9+MAX(0,(Business!B6-50)/Business!B10,0))

#VALUE is currently displayed in Cell C36 on my Total tab/sheet when there
are not any numbers in the cells on the €œBusiness€� tab/sheet. I want Cell
C36 to read zero on the Total tab/sheet in lieu of #VALUE. Cell C36 should
read a number when there are numbers in the cells on the €œBusiness€� tab/sheet.

Can anyone assist me on this?

Thank you