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 a certain % lets say 100%.  Have attached an image to explain this better.  So if column A > column B 100% or more it is marked by x.

 

Thanks,

Simon

 

 

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.

3 Replies

  • 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.

Resources