Defining if a cell has an letter / number with in it using IFstate

  • Thread starter Thread starter Washeacrim
  • Start date Start date
W

Washeacrim

In a IF statement how do i determine a letter or a number within a cell using
Excel 2007

ie IF(D3 = letter; then 1 ; else 0)

Thanks
 
=IF(ISNUMBER(D3), "It's a number", "It's text or Boolean")
=IF(ISNUMBER(D3), 1,0)

But the IF is not needed when you want just 1 or 0
=--ISNUMBER(D3)
The double unary negation converts Boolean TRUE/FALSE to numeric 1/0

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert a number to letter 2
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Replace letters with Plus Sign 3
Nested IF statments 3
Excel Use COUNTIF across a range of cells with formulas 0
find the highest letter/number combination 4
Excel Convert word into numbers and back 4
Count in a range of numbers 8

Back
Top