I am trying to get rid of some really pesky DIV/0 and #VALUE errors. The formula I would like to create would look at range1, decide if the total is zero, display zero and then look at range2, decide if that total was zero and then disply zero, additionally, if the totals were not zero then it would perform a further calculation of totaling range1 and then totaling range2 and dividing range1 by range2
I have tried many variations of this formula without success. =IF('Staff Detail'!S15:S25=0,0,IF(C10:C11=0,0))+SUM('Staff Detail'!S15:S25,/C10:C11)
Any blatant errors you can point out would be sincerely appreciated!
I have tried many variations of this formula without success. =IF('Staff Detail'!S15:S25=0,0,IF(C10:C11=0,0))+SUM('Staff Detail'!S15:S25,/C10:C11)
Any blatant errors you can point out would be sincerely appreciated!