Using IFERROR and IF Statements together

[Benny236]

Hi all

I would like to be able to use IFERROR and an IF statement in one formula. I would like a box to say nothing ("") if the box says "VALUE!" or "£0.00". How do I do this?

The math I'd like to include is:

A3/10

So something like IF(A3/10 = 0, "", A3/10) which works for the "£0.00", but not for the "VALUE!" issue.


Thanks.

 

[Fishboy]

Hi all

I would like to be able to use IFERROR and an IF statement in one formula. I would like a box to say nothing ("") if the box says "VALUE!" or "£0.00". How do I do this?

The math I'd like to include is:

A3/10

So something like IF(A3/10 = 0, "", A3/10) which works for the "£0.00", but not for the "VALUE!" issue.


Thanks.

Hi Benny236,

I cannot figure how anything other than 0 divided by 10 would be 0, so your formula should always display the A3/10 result instead of the "".

To wrap this in an IFERROR statement it should be as simple as this:

=IFERROR(IF(A3/10=0,"",A3/10),"")

 

[Benny236]

That's perfect. I knew it would be simple like that but wasn't exactly sure of the syntax. Thanks very much for your help Fishboy!

 

[Fishboy]

That's perfect. I knew it would be simple like that but wasn't exactly sure of the syntax. Thanks very much for your help Fishboy!

No worries, happy to help mate

 

[Aladin Akyurek]

=IF(ISNUMBER(A3),A3/10,"")

would be more appropriate and a tad cheaper.