NadoDude
Board Regular
- Joined
- Jun 24, 2010
- Messages
- 84
I am using the following formula:
=IF(AND($W5956="",$X5956=""),0,IF($Q5956="Deployment",0,IF(AND($P5956="",$N5956=""),0,IF(AND($P5956<>"",$P5956<$W5956),0,IF($P5956="",TODAY()-IF($N5956<$W5956,$W5956,$N5956),$P5956-IF($N5956<$W5956,$W5956,$N5956))))))
I tried to modify the second IF statement IF($Q5956="Deployment", to return a 0 if the $Q5956 starts with the word Deployment by adding an * after the word Deployment:
=IF(AND($W5956="",$X5956=""),0,IF($Q5956="Deployment*",0,IF(AND($P5956="",$N5956=""),0,IF(AND($P5956<>"",$P5956<$W5956),0,IF($P5956="",TODAY()-IF($N5956<$W5956,$W5956,$N5956),$P5956-IF($N5956<$W5956,$W5956,$N5956))))))
The first formula returns a 0, but the second formula does not. What am I missing?
=IF(AND($W5956="",$X5956=""),0,IF($Q5956="Deployment",0,IF(AND($P5956="",$N5956=""),0,IF(AND($P5956<>"",$P5956<$W5956),0,IF($P5956="",TODAY()-IF($N5956<$W5956,$W5956,$N5956),$P5956-IF($N5956<$W5956,$W5956,$N5956))))))
I tried to modify the second IF statement IF($Q5956="Deployment", to return a 0 if the $Q5956 starts with the word Deployment by adding an * after the word Deployment:
=IF(AND($W5956="",$X5956=""),0,IF($Q5956="Deployment*",0,IF(AND($P5956="",$N5956=""),0,IF(AND($P5956<>"",$P5956<$W5956),0,IF($P5956="",TODAY()-IF($N5956<$W5956,$W5956,$N5956),$P5956-IF($N5956<$W5956,$W5956,$N5956))))))
The first formula returns a 0, but the second formula does not. What am I missing?