isnumber formula?

[Todd]

Hi. I am using a formula that calculates from a range of
cells that might be blank, or might have a formula that
returns a number, a zero or a "". I have a formula that
works but I am hoping to simplify it. By using isnumber
or something like that. Any ideas?

=IF(AND(EE13<>"",EE13<>0),IF(EE13>0,ROUND
($E13*EE13,0),""),"")

I can have as many as 5 cells that I need to choose if
they have a "-"or "+" number other than 0.

TIA

Todd

 

[Aladin Akyurek]

It looks like you want...

=IF(N(EE13)>0,ROUND($E13*EE13,0),"")