# 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!
Related:

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)))
TanyaRT Posts 7 Registration date Sunday November 16, 2014 Status Member Last seen August 20, 2015
Nov 17, 2014 at 12:03 AM
Thanks!