ExcelBanter - If IsError Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If IsError Help (https://www.excelbanter.com/excel-discussion-misc-queries/243308-if-iserror-help.html)

Karin

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.

Mike H

If IsError Help

Hi,

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

Mike

"Karin" wrote:

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.

All times are GMT +1. The time now is 05:52 AM.