Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Help
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|