MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Please help w/ IF Statement.


Posted by Gern Blanstin on April 13, 2001 3:57 PM

I need to combine these into one IF statement:
=IF(E10<50.00,"PROCESS TRANSACTION","ASK FOR A CHECK-CASHING CARD")
=IF(D7="TRUE","PROCESS TRANSACTION","ASK FOR CASH OR CREDIT CARD")

Thanks!
Gern


Posted by Mo on April 13, 2001 4:13 PM

Hello Gern,
Try this
=IF(E10<50,"PROCESS TRANSACTION",IF(D7="true","PROCESS TRANSACTION","ASK FOR CASH OR CREDIT CARD"))


Posted by Mo on April 13, 2001 4:21 PM

Oops


Sorry Bern, The first reply is wrong, This is my second dig.
=IF(E10<50,"PROCESS TRANSACTION",IF(E10<>50,"ASK FOR A CHECK-CASHING CARD",IF(D7="True","PROCESS TRANSACTION",IF(D7<>"True","ASK FOR CASH OR CREDIT CARD","PROCESS TRANSACTION"))))

Posted by Gern Blanstin on April 13, 2001 4:48 PM

Thanks For your help!

This is my problem:

Develop a formula using the IF function for the following conditions. A retail store has this check cashing policy:
a. The customer must have a valid driver's license.
b. When the check is for more than $50, the customer must have check-cashing card on file.

Thanks!
Gern

Posted by Aladin Akyurek on April 14, 2001 12:28 AM

Gern

I'm not sure I fully understood the policy, here is my guess:

=IF(D7,IF(E10<=50,"PROCESS TRANSACTION","ASK FOR A CHECK-CASHING CARD"),"ASK FOR CASH OR CREDIT CARD")

Aladin

Posted by Gern Blanstin on April 14, 2001 12:35 PM

ALADIN, YOUR A GOD!

THANK YOU!!!

Gern