Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Here is my dilemma folks:
Column A B Row 1 900 1000 Row 2 500 1000 I want to say in C1 and C2: If A1 is 10 to 20% below B1 then TRUE if not FALSE. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
One way:
=AND(A1<=B1*90%,A1=B1*80%) In article , Fgbdrum wrote: Here is my dilemma folks: Column A B Row 1 900 1000 Row 2 500 1000 I want to say in C1 and C2: If A1 is 10 to 20% below B1 then TRUE if not FALSE. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|