Problem with Nested IF

[perfecttip]

I have three columns of data.. A, B and C. A and B contain numerical values and C is blank. I need a formula for the column C so that
if A>B, then C = "more" (text)
if A<B, then C = "less" (text)
if A=B, then C remains blank.

Please help.
Thank you.

 

[Diablo II]

try

=IF(A15>B15,"more","")

 

[perfecttip]

That does not take care of all the conditions

 

[Diablo II]

it will do what you asked and the only thing you asked. if A is grater then B the word more will be in C if A is less then B c will stay blank.

 

[lenze]

ADVERTISEMENT

Hi and welcome to the board!!

Diablo's formula takes care of all the conditions you mentioned. What other conditions are there? Perhaps

=IF(A2>B2,"More",IF(A2=B2,"","Less"))

lenze

 

[perfecttip]

god knows whats wrong.. i edited the post thrice and still the entire thing does not appear.. let me try putting it in words....
if A is greater than B then C is "more", if A is lesser than B then C is "less", if A is equal to B then C is blank. Thank you.

 

[perfecttip]

ADVERTISEMENT

yeah.. putting the entire matter in words worked..

 

[lenze]

So, see my above post!!
lenze
NOTE: A "<" will sometimes be interpreted as the beginning of an HTML statement. You need to place a space before and after any "<"

 

[perfecttip]

@lenze

thanks for your help.. but its not working
it returns "less" even when both the values of A and B are equal.

 

[lenze]

Re: @lenze

Are you sure?

=IF(A2>B2,"More",IF(A2=B2,"","Less"))

works fine for me

lenze