# Excel help

Closed
Posts
1
Registration date
Thursday April 30, 2015
Status
Member
Last seen
April 30, 2015
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
I think I need to use multiple formula to find this. I think an If function is used for sure. I need to find a formula that gives me the difference between the shipping days and promised days in negative/positive numbers. There are three different criteria to consider here.

One to find the difference between (shipping days-promised shipping days) in positive/negative number

Second if shipping = promised then 0

Third if the customer had paid for expedited shipping, 2 days are subtracted from the promised days.

I have been trying to solve this for days :( i could also sent the excel file, if my question doesnt make sense

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Nele,

So your sheet looks a bit like:
Column A: Shipping days
Column B: Promised shipping days
Column C: Paid? (either Yes or No)

Column D could then have the formula:
=IF(C2="Yes",B2-2,A2-B2)

Otherwise a data sample would be handy.

Best regards,
Trowa