Weird behavior of excel

I have the below information in my excel

A1: String value of 10+20

A2: Number 5

In A3 I am reading the number before “+” in A1 using “=Left(A1, Find(“+”,A1)-1)”. I got the number 10

I want to have a formula in my A4 whereby I should compare A3 with A2. If A3 less than or equal to A2 return “True” else return “False”. So I had the standard if condition “=if(A3<=A2,”True”,”False”)”

But the if condition does not work since the number in A3 is a formula generated number and not a keyed in number.

How to fix the problem??

Try this: =LEFT(A1,FIND("+",A1)-1)+0

or

=LEFT(A1,FIND("+",A1)-1)*1

or

=IF(A2<=A3+0,"True","False")

or

=IF(A2<=A3*1,"True","False")

Since the LEFT function returns text, you have to force Excel to convert it to a number before you can perform a <= operation on it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Did you watch the X-Files when it was on TV?

Discuss in The Lounge

Poll History