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