Forum Discussion

Simon77710's avatar
Simon77710
Copper Contributor
Jan 04, 2020
Solved

Excel - IF cell X > than cell Y by %

Hi,   I was wondering if someone could help me with the following.   I have a sheet with data in column A + column B Would like to have a formula that will mark cells if the value is greater by ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 04, 2020

    Simon77710 

    Simon, in C1 it could be

    =IF(A1>=B1*2,"x","")

    and drag it down.

    Alternatively you may apply conditional formatting rule to entire range with formula like

    =$A1>$B1*2

    and with desired format.

    Instead of B1*2 it could be B1*1.5 for 50%, etc. Even better to keep percent in helper cell, let say E1. When B1*(1+$E$1). In E1 it could be 100%, 50%, whatever.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 04, 2020

Simon77710 

Simon, in C1 it could be

=IF(A1>=B1*2,"x","")

and drag it down.

Alternatively you may apply conditional formatting rule to entire range with formula like

=$A1>$B1*2

and with desired format.

Instead of B1*2 it could be B1*1.5 for 50%, etc. Even better to keep percent in helper cell, let say E1. When B1*(1+$E$1). In E1 it could be 100%, 50%, whatever.

  • Simon77710's avatar
    Simon77710
    Copper Contributor
    Jan 04, 2020

    SergeiBaklanPerfect, should have known that but wasn't sure how to express in formula.  Many thanks Sergei!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 04, 2020

      Simon77710 , you are welcome, glad to help

Resources