I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe

Hi W. Wolfe,

To distinguish between letters and numbers in an IF statement, you can use the ISNUMBER function and the ISTEXT function.

Here's an example of how you can use these functions in an IF statement:

1. =IF(ISNUMBER(A1), "Do something if it's a number", IF(ISTEXT(A1), "Do something if it's a letter", "Do something else if it's neither a number nor a letter"))

In this example, A1 is the cell you want to check. The first part of the IF statement checks if A1 contains a number using the ISNUMBER function. If it does, the statement returns "Do something if it's a number". If it doesn't, the second part of the IF statement checks if A1 contains a letter using the ISTEXT function. If it does, the statement returns "Do something if it's a letter". If A1 contains neither a number nor a letter, the statement returns "Do something else if it's neither a number nor a letter".

Hi,

Try this

=IF(ISNUMBER(A1),"Do number things",IF(NOT(ISBLANK(A1)),"Do text things","Do
neither, it's blank"))

Mike

"William Wolfe" wrote:

I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe

On Fri, 31 Jul 2009 14:34:04 -0400, "William Wolfe"
wrote:

I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe


=if(isnumber(cell_ref),"do this","do that")
--ron

Use the ISNUMBER function...

=IF(A1="","I'm blank",IF(ISNUMBER(A1),"I'm a number","I'm text"))

--
Rick (MVP - Excel)


"William Wolfe" wrote in message
...
I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe

Thanks for your quick response.

W. Wolfe


"Rick Rothstein" wrote in message
...
Use the ISNUMBER function...

=IF(A1="","I'm blank",IF(ISNUMBER(A1),"I'm a number","I'm text"))

--
Rick (MVP - Excel)


"William Wolfe" wrote in message
...
I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe

I love these answers! thank you that is so very helpful.

I have been searching for something like this but with a twist.

What if you have numbers and letters in the cell. is there a way to tell it to show just the letters or the numbers as the answer???

thank you

PS: I did not want to start a whole new thread, I will hopefully get the answer here.
if not I will start one another time.