Multiple Ifs - Then Statement

[kimberlyre2000]

I am trying to write a formula as follows:

First Credit Approved Result
Kim Credit If A is "blank" and B is not "Credit", then "No First Name")
Sue Credit
Sam Credit
Credit
Jen Credit
Andy Credit

Thank you....

[Moo the Dog]

Try this:

=IF(AND(ISBLANK(A1),B1<>"Credit"),"No First Name","")

- Moo

[kimberlyre2000]

When I type the formula, I am not getting a "No First Name" for the fourth row...

[Moo the Dog]

Of course it won't, because your requirement was: If A is blank AND if B is not "Credit", so that is how I wrote the formula.

You can change it to this and try: =IF(ISBLANK(A1),"No First Name",IF(B1<>"Credit","No Credit",""))

That will check if A1 is blank. If it is, then "No First Name" will appear. If there is a first name, then it checks to see if B1 = Credit. If it is not there, the result will show "No Credit". If both conditions prove false (meaning there IS a first name and the word Credit is in B1, then the cell with the formula in it will remain blank.

- Moo

[kimberlyre2000]

Okay. Thank you.

[Moo the Dog]

You're welcome. Glad I could help.

- Moo