If IsError Help

[Karin]

My formula:
=IF(SUM(Q20:R20)>S20,"over budget",SUM(Q20:R20)/S20)

If there is a division error on the last part, I need to have it return ""

Not sure how to get this to work.

Thank you.

 

[Mike H]

Hi,

=IF(S20=0,"",IF(SUM(Q20:R20)>S20,"over budget",SUM(Q20:R20)/S20))

Mike