Good afternoon! I'm working on a formula for Column C to add days to the start date based on the type. Below is the formula I'm trying to use. It works perfectly when the type = "Testing", however, I'm not getting a "N/A" result when the type equals "Monitoring". Can someone take a look at this for me and let me know where I'm messing up?
FORMULA USED:
=IF(B2="","",IF(A2="Testing",B3+3,"N/A"))
DATA:
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
FORMULA USED:
=IF(B2="","",IF(A2="Testing",B3+3,"N/A"))
DATA:
Type | Start Date | Milestone 1 | End Date |
Testing | 1/30/2018 | ||
Monitoring | 1/1/2018 | 1/30/2018 | |
Testing | 1/1/2018 | 1/30/2018 | |
Monitoring | 1/1/2018 | 1/30/2018 |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>