IF function formula based on three possible values from adjacent

Solved/Closed
TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015
- Nov 16, 2014 at 04:42 PM
TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015
- Nov 17, 2014 at 12:03 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Nov 16, 2014 at 10:59 PM
=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)))
0
TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Status
Member
Last seen
August 20, 2015

Nov 17, 2014 at 12:03 AM
Thanks!
0