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. |
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. |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com