IF Formula Help
One way:
C1: =A1<=(B1*80%)
(assumes both A1 and B1 are positive)
In article ,
Fgbdrum wrote:
Here is my dilemma:
Columns
A B
Row 1 1500 5000
In cell C1 I want to put a formula in that says this:
If A1 is 20% or more below B1, then give me TRUE otherwise give me FALSE.
Any help is always appreciated. Thank you.
|