If (ISERROR) formula

[Paul35Hants]

Hello All,

I wondered if someone could help me.

I have 3 columns in excel:

Column 1 is my budget
Column 2 is how much of the budget I have consumed to date.
Column 3 I have my formula.

In this formula I wish to show the following:

a) if Column 2 / Column 1 is > 60% then show "YES" else "NO" - I have done this part.
b) if Column 2 / Column 1 returns #DIV/0! then I wish to return "Check"

Its part b) I am struggling to include within the full formula.

Can anyone help?

Thanks

Paul

 

[VoG]

Try

=IF(A1="","Check",IF(B1/A1>60%,"Yes","No"))

 

[adam087]

What are you trying to achieve?

=IF(ISERROR([your formula]), "Check", [your formula])

would achieve what you want but there's a danger that you'd miss other errors it generates as well and therefore not get an accurate output.

Might be better to check something else?

Regards
Adam

 

[Paul35Hants]

Works perfect. Many thanks