IF condition

[sriku]

Hi,

Can any one Help me getting this in out put as mentioned in attachment:

My Base date is 1st April 2015
if is delivery date is less than my Base date then my output 4 else 6 (Total Tat)
then once Total Tat difference with process date


Thanks,
Sriku

[Kaper]

Start with D2:

Please Login or Register  to view this content.

as for this part:

then once Total Tat difference with process date

note that in a sample workbook we love if you:
Make sure there is just enough data to demonstrate your need.
Make sure your desired results are shown, mock them up manually if necessary.

may be this is just (in D2):

Please Login or Register  to view this content.

but until you show us - it is only guessing

[adhawan06]

Hi sriku,

I have attached a file for your reference. Have done the 1st criteria however, couldn't able to understand the 2nd criteria. Can you please explain bit more?