Forum Discussion
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 ...
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*2and 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.
SergeiBaklanPerfect, should have known that but wasn't sure how to express in formula. Many thanks Sergei!
Simon77710 , you are welcome, glad to help