IF Formula Greater than

**hkbhansali** · 12-22-2013, 10:09 AM

I am trying to find a formula that allows for the following:

CELL A1 100
CELL B1 50
CELL C1 40

In CELL D1 I Want IF A1 is greater than B1 (40 BY CELL C1) RESULT WILL BE "OK" IN CELL D1,
otherwise "NOT OK" ( CELL A1 & B1 Will Change time to time)

Thanks in advance.

**etaf** · 12-22-2013, 10:24 AM

for A1 greater than B1

=IF( A1>B1, "OK", "Not OK")

if A1 needs to be greater than B1 by or equal to the value in C1

(A1-B1)>=C1

=IF( (A1-B1)>=C1, "OK", "Not OK")

**hkbhansali** · 12-22-2013, 10:40 AM

Thanks etaf,

Thanks for Quick Responce.

Regards,
hkbhansali

**etaf** · 12-22-2013, 02:47 PM

your welcome

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.