Excel help

Closed
Report
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.

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

1 reply

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