Simple if statements

[maunettia]

This should be simple but I am new to if statements:
Column A has either a date or Pending or Not Taken type into the rows
If a particular row in Column A has a date then that same row in Column C should say "Funded"
If a particular row in Column A has Pending then that same row in Column C should say "Pending"
If a particular row in Column A has Not Taken then that same row in Column C should say "Not Taken"

How do I generated a working statement?

 

[jeffreybrown]

Hello & Welcome to the Board,

Something like this...

=IF(ISNUMBER(A1),"Funded",IF(A1="Pending","Pending",IF(A1="Not Taken","Not Taken")))

 

[maunettia]

It only gives False

 

[jeffreybrown]

Did you put anything in A1? FALSE tells me A1 is blank...

Try...

=IF(ISBLANK(A1),"",IF(ISNUMBER(A1),"Funded",IF(A1="Pending","Pending",IF(A1="Not Taken","Not Taken"))))

or

=IF(A1<>"",IF(ISNUMBER(A1),"Funded",IF(A1="Pending","Pending",IF(A1="Not Taken","Not Taken"))),"")

 

[maunettia]

OMG you are so good and so right I didn't anything in A1
Bless your heart and thank you so much

 

[jeffreybrown]

Thanks for the feedback and glad you got it working

 

[Rick Rothstein]

This should be simple but I am new to if statements:
Column A has either a date or Pending or Not Taken type into the rows
If a particular row in Column A has a date then that same row in Column C should say "Funded"
If a particular row in Column A has Pending then that same row in Column C should say "Pending"
If a particular row in Column A has Not Taken then that same row in Column C should say "Not Taken"

How do I generated a working statement?

You did not give us complete information. So, assuming that the only values that will be in Column A are a blank cell, a date or the text Pending or Not Taken, then this formula should work for you...

=IF(ISNUMBER(A1),"Funded",IF(A1="","",A1))