Multiple Condition If Statement

[Nanogirl21]

Hi, Can someone please help me create 1 formula with the conditions below. The formula will be in cell P2. I appreciate the help.

If W2 says CLOZ then Y2-AE
If W2 says CANCELLED then Y2-AF
If W2 says anything other than CLOZ or CANCELLED then Today()-1-Y2

 

[Scott T]

I assume that AE and AF were suppose to be cell references AE2 and AF2. Try

=IF(W2="cloz",Y2-AE2,IF(W2="cancelled",Y2-AF2,TODAY()-1-Y2))

 

[Nanogirl21]

I assume that AE and AF were suppose to be cell references AE2 and AF2. Try

=IF(W2="cloz",Y2-AE2,IF(W2="cancelled",Y2-AF2,TODAY()-1-Y2))

Thank you. That worked perfectly.

 

[Scott T]

Glad to help.