if statement

[denise]

Hello,

I need a formula that says that if this cell is equal to a
number than do the calculation otherwise blank. I have
text and numbers mixed together so I need to basically get
rid of the text. Any suggestions?

Thank you,

Denise

 

[Don Guillett]

see if this works

=IF(ISERR(D9*3),"",D9*3)

 

[Bob Phillips]

Denise,

Like this?

=IF(ISNUMBER(A1),A1*5,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

Hello,

I need a formula that says that if this cell is equal to a
number than do the calculation otherwise blank. I have
text and numbers mixed together so I need to basically get
rid of the text. Any suggestions?

Thank you,

Denise

Something like:

=IF(ISNUMBER(A1),your_formula,"")


--ron

 

[Abhay Shah]

I'm actually a big fan of the LEN statement -- it goes
something like:

IF(LEN(A1)=X,then statement, else statement)