Previous Topic Next Topic

Excel help

Closed
nele8118 Posts 1 Registration date Thursday April 30, 2015 Status Member Last seen April 30, 2015 - Apr 30, 2015 at 08:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 30, 2015 at 11:10 AM
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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 30, 2015 at 11:10 AM
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
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses