How do I - Logical Test: If a cell's value is not a number?

[bobwhosmiles]

Hi,

I have a cell that totals the values on a sheet gathered by other formulas. If values aren't yet present they'll obviously display #VALUE! as they don't result in a number.

I need a way to say (for example) in a formula:

If a given cell doesn't equal an actual number and so reports an error, display nothing.

OR incorrectly =IF(A1="#VALUE!","",A1)

Hopefully this makes sense.

Any help appreciated

Cheers

Bob

 

[Aladin Akyurek]

Re: How do I - Logical Test: If a cell's value is not a numb

What formula are you using that results in #VALUE! errors?

 

[DRJ]

Hi - Welcome to the board

=IF(ISERROR(A1),"",A1)

 

[Nimo]

Re: How do I - Logical Test: If a cell's value is not a numb

Try

=IF(ISERROR(your formula),"")

Nimo

 

[bobwhosmiles]

Re: How do I - Logical Test: If a cell's value is not a numb

Thanks loads for a solved query and a speedy and friendly welcome to the board.

That has completely sorted it. Plus I've just discovered the numerous IS functions that will help me in other similar circumstances.

Typically, Excel's own "Answer Wizard" failed to offer an answer despite rephrasing the query numerous times

Thanks

Bobwhosmiles (again)

 

[DRJ]

Your're Welcome

Take Care

 

[NateO]

Re: How do I - Logical Test: If a cell's value is not a numb

=IF(ISNUMBER(a1),a1,"")

 

[Aladin Akyurek]

Re: How do I - Logical Test: If a cell's value is not a numb

...That has completely sorted it. Plus I've just discovered the numerous IS functions that will help me in other similar circumstances.

I guess it won't help saying that an IsError test is most of the time not the way to resolve the problem.

Typically, Excel's own "Answer Wizard" failed to offer an answer despite rephrasing the query numerous times...

Maybe it doesn't like invoking IsError...

 

[Nimo]

Re: How do I - Logical Test: If a cell's value is not a numb

Hi Aladin,
What would you have suggested?

Nimo (still learning)