Is there a way to construct the formula below so that when E$15 is 0 that this #DIV/0 does not happen? I would prefer it to just be blank or return a result of 0 and not this error. Can my formula be changed so I can achieve this?
=((F9*3)+(H9*2)+(J9*1)+(L9*1)+(N9*2)+(P9*0.25)+(R9*-1)+(T9*5)+(V9*0.2)+(X9*3))/E$15
Thanks,
Bill
=((F9*3)+(H9*2)+(J9*1)+(L9*1)+(N9*2)+(P9*0.25)+(R9*-1)+(T9*5)+(V9*0.2)+(X9*3))/E$15
Thanks,
Bill