#DIV/0 Question/help

[easybpw]

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

 

[Joe4]

Try:

=IF(E15,((F9*3)+(H9*2)+(J9*1)+(L9*1)+(N9*2)+(P9*0.25)+(R9*-1)+(T9*5)+(V9*0.2)+(X9*3))/E$15,0)

 

[easybpw]

Thanks, just what I was hoping for.

Bill