Thread: If IsError Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karin Karin is offline
external usenet poster
 
Posts: 125
Default If IsError Help

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.