Share via

IF function of Increase decrease and Equal

Anonymous
2022-11-01T13:34:58+00:00
A B C D
A 21 46 Decrease
B 0 0 Equal
C 18 2 Increase

I currently fill in the D column manually.

I wonder if there any "IF"formula that can use for 3 selection of answer.

I used =IF(B2>C2;"Increase";"Decrease") before but I wonder If I can make them like B2=C2 then "Equal"

I tried =IF(B2>C2,"Increase",IF(B2<C2,"Decrease","Equal")) but does not seem to work.

Thank you

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-01T13:59:01+00:00

    My guess: the data in some or all cells (for example B2 and/or C2) is type text.

    Note that I write "type", not "format". The format of the cell does not matter, and looks can be deceiving, including horiontal alignment.

    Use formulas of the form =ISTEXT(B2) and =ISTEXT(C2) to determine data type.

    In Excel, a text value is considered greater than any numeric value. And text is compared based the ASCII value of characters. So, for example, the string "2" is greater than the string "18".

    You might convert the text data to numeric by using the Text To Columns feature on each column of data individually.

    Was this answer helpful?

    0 comments