 • 512K Members
• 7,527 Online
• 609K Conversations

# Excel If Functions

I created If function as shown in attached picture =if (c1>=10;2;0) then if I type a letter or text into c1 it show me the true value
Why excel understand that letter or text as number >=10
10 Replies

# Re: Excel If Functions

In Excel with comparing operators any logical value is always more than any text, and any text is always more than any number.

# Re: Excel If Functions

But how I can fixed this I need to type text and the value not change or give me the value if false

# Re: Excel If Functions

Sorry, I didn't catch. You type some text in c1 and compare it with 10. When you'd like to have TRUE and when FALSE, for which combination of text and 10?

# Re: Excel If Functions

I want if I type the text in C1 give me the value if false in D1

# Re: Excel If Functions

When I type text in C1 it give me the value if false in D1 not the value if true

# Re: Excel If Functions

So, to return

if in C1 is text AND in D1 is FALSE then value

and

Where to take value?

If in C1 is text and in D1 is TRUE?

If in C1 is not text?

As a staring point you may use check ISTEXT(C1) and build logic based on it

# Re: Excel If Functions

Kindly see this attached file
When I type the letter A or text in C1 it give me the true value 2
And if I type 10 it give me same value

# Re: Excel If Functions

Perhaps

`=IF(ISNUMBER(C1)*(C1>=10),2,0)`

# Re: Excel If Functions

You are welcome, glad to help

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies
Returning list from 3D array
Paul Danaher in Excel on
17 Replies