IF Formula Help

[Guest]

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.

 

[JE McGimpsey]

One way:

C1: =A1<=(B1*80%)

(assumes both A1 and B1 are positive)