Previous Topic Next Topic

IF function formula based on three possible values from adjacent

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

Answer 1 / 1
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)))
0
TanyaRT Posts 5 Registration date Sunday November 16, 2014 Status Member Last seen August 20, 2015
Nov 17, 2014 at 12:03 AM
Thanks!
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response