Double "IF" Formula

[Utradeshow]

Hi Guy's

I have this formula that works good when I have a date in cell T27. Is there a way to also have it look at T27 and if the value is "___/___/___" then the result would be "Please confirm within 96 hours"

=IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')","")

Thank you

 

[poolhall]

=IF(T27="___/___/___","Please confirm within 96 hours",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')",""))

 

[T. Valko]

Hi Guy's

I have this formula that works good when I have a date in cell T27. Is there a way to also have it look at T27 and if the value is "___/___/___" then the result would be "Please confirm within 96 hours"

=IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')","")

Thank you

Do you mean you have the literal string, ___/___/___, in the cell? Or, does that mean the cell is empty?

 

[Utradeshow]

=IF(T27="___/___/___","Please confirm within 96 hours",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')",""))

Awesome!! Dang I was trying so many way trying to get it. Thank you Works great

 

[Utradeshow]

Do you mean you have the literal string, ___/___/___, in the cell? Or, does that mean the cell is empty?

Hi Bill,

The cell's value is "___/___/___"

But now i have trouble, Is there a way to have the date formula to AVOID weekends? If the result returns a date that is Saturday, it would kick it back to Friday?

=IF(T27="___/___/___","Please confirm order 96 hours prior to loading",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')",""))

 

[T. Valko]

Hi Bill,

The cell's value is "___/___/___"

But now i have trouble, Is there a way to have the date formula to AVOID weekends? If the result returns a date that is Saturday, it would kick it back to Friday?

=IF(T27="___/___/___","Please confirm order 96 hours prior to loading",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4,"mm/dd/yy")&"')",""))

What is the significance of the -4 in the formula:

TEXT(T27-4

 

[Utradeshow]

What is the significance of the -4 in the formula:

TEXT(T27-4

4 days prior to the value (Date) of cell T27

So right now if the value of cell T27 is 05/25/11 the result of the formula would be 05/21/11 which is a Saturday. I would like the result to then be 5/20/11

 

[Utradeshow]

4 days prior to the value (Date) of cell T27

So right now if the value of cell T27 is 05/25/11 the result of the formula would be 05/21/11 which is a Saturday. I would like the result to then be 5/20/11

I found this formula that I think you guy's actually did whick works great, If I could just incorporate it into my existing formula

=T27-4+LOOKUP(WEEKDAY(T27-4),{1;2;7},{-2;0;-1})

 

[Utradeshow]

Somehow I think Idid it....

=IF(T27="___/___/___","Please confirm order 96 hours prior to loading",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4+LOOKUP(WEEKDAY(T27-4),{1;2;7},{-2;0;-1}),"mm/dd/yy")&"')",""))

Seems to work great

 

[T. Valko]

Somehow I think Idid it....

=IF(T27="___/___/___","Please confirm order 96 hours prior to loading",IF(AA15="TRANSPORTATION PROPOSAL","(Please Confirm Order on or by '"&TEXT(T27-4+LOOKUP(WEEKDAY(T27-4),{1;2;7},{-2;0;-1}),"mm/dd/yy")&"')",""))

Seems to work great

Good deal. Thanks for the feedback!