if statement

  • Thread starter Thread starter denise
  • Start date Start date
D

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
 
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)
 
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
Click to expand...

Something like:

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


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

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