• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to Be Constant

T

Tarun.M

New Member
Please help me with below formula:

=IF(G2="HOLD",F2+52,IF(G2="SUBMITTED",H2+45)).


I want formula to change only for Hold & to be Submitted condition. For rest conditions like Awaiting CTC,Cancelled,Clearing Conditions etc the formula should show the hold or submitted condition dates as per the conditions.


G2 column has various conditions, F2 Columns has Date Received & H2 Columns has Date Submitted date.
 
Hi, Tarun.M!


I'm afraid I don't fully understand your problem. Would you please clarify it or upload a sample file?


For what I understood one approach might be:

=IF(G2="HOLD",F2+52,IF(G2="SUBMITTED",H2+45,<neither_hold_nor_submitted>))

where <neither_hold_nor_submitted> is the missing action for false condition of the 2nd nested IF function.


Hope it helps.


Regards!
 
You must log in or register to reply here.
Back
Top