Hi Excel Ninjas,
I have a table of fruit selling. In this table there are certain categories for the customer to have different price for different booking window. Start from last minute order 16 days in advance will get 5% upto 90 days in advance will get 25% of Banana Master Price. I would like to know how I can apply this on excel:
regards,
kean
I have a table of fruit selling. In this table there are certain categories for the customer to have different price for different booking window. Start from last minute order 16 days in advance will get 5% upto 90 days in advance will get 25% of Banana Master Price. I would like to know how I can apply this on excel:
 what kind of formula that can refer the “date” to count the booking window
 how can the formula detect if the date is keep changing day by day ie: today is 10 September and tomorrow is 11 September and so on
regards,
kean
Attachments

10.9 KB Views: 3