IF function formula based on three possible values from adjacent [Solved/Closed]

Report
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015
-
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015
-
Good morning all,

Excel 2007 - I need a formula based on the three possible values from an adjacent cell.

1st value: : if F5 is a date, a simple formula will need to be applied to G5 eg: F5+731 (the number of days added to the date will be the same for all cells in the column
2nd value: If F5 is "Pending", G5 will display "TBC"
3rd value: If F5 is "TBC", G5 will also need to be "TBC"

I can get the first two to apply using the IF, otherwise
=IF(F5="Pending", "TBC", (F5+731))
But I cant figure out how to get the third value in

Little Help!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
=IF(F5="Pending", "TBC", (F5+731))


One way
=IF(OR(F5="Pending", F5 = "TBC"), "TBC", (F5+731))

Other way
=IF(F5="Pending", "TBC", IF(F5="TBC", "TBC", (F5+731)))
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015

Thanks!