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
