IF formula variables to return more than one answer depending on another cell input

Hi everyone...

I have a formula that has a couple of variables. I would like to be able to return more than one answer dependent on what another cell says...

Basically my A cell could have a few variables...
It may say - N/A (not applicable)
or - TBD (to be determined)

My formula in cell B is dependent on the above...
I want to create an if formula, but it has to return another answer too... (if the cell in cell A says TBD, i want to mark it as pending which i can do...)

SO, (if you are still reading this!), so far I have in the B column:
=IF(A1="N/A", "N/A", "PENDING")
so how do i add the variable that if it is says TBD, that it copies that instead...

Thank you in advance, as always!

tina x

i tried this, but it didnt work... but may give a jist of what i am trying to achieve...

=IF((a1="N/A", "N/A", "PENDING")(a1="TBD", "TBD"))

basically, these are the possibilities i am to use in the spreadsheet...

if:

A= n/a, B= n/a
or
A= tbd, B= tbd
or
A= (has a date in it, or is NOT n/a and NOT tbd), B= PENDING

does that make sense?

hi hun, it didnt work, it did the following:

if:
A= (date), b= blank (want it to say pending)
A= tbd, b=pending (want it to say tbd)
a= n/a, b= n/a (this is ok)

thank you for your help so far tho... i havent heard of the 'choose' function!
t x

hi dave,

I LOVE YOU!
thank you sooo much!!!

You are getting a STAR!
t x

Don't worry hun, no one loves me either. At least we will always have our special Excel moments!