If IsError Help

  • Thread starter Thread starter Karin
  • Start date Start date
K

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.
 
Hi,

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop #DIV/0! when some of my values are zero? 3
Move one cell to another 4
How can I get around 30 argument limit of SUM function? 4
Simplicity is Desired 8
Help with Formula Scenarios from yesterday 3
Use index function to return formula 3
CountA question 2
Excel 2003 code to use instead of ChartObjects 4

Back
Top