Dear All,
I need to do the following:
I have a price increase for item 12345 for
a.) 100 - 200 = 1.5$
b.) 200 - 300 = 1.4$
c.) 300 - 400 = 1.3$
I have a history for 12345 from the last year where sometimes it was ordered in the following quantities:
1.) 100 (would be 1.5)
2.) 200 (would be 1.4)
3.) 305 (would be ???)
The thing here is, I can not use sumproduct() for history values that are different from the standard quantities defined under a.b.c.
Can the sumproduct be changed to also allow checking values which are different from the standard values?
I need to do the following:
I have a price increase for item 12345 for
a.) 100 - 200 = 1.5$
b.) 200 - 300 = 1.4$
c.) 300 - 400 = 1.3$
I have a history for 12345 from the last year where sometimes it was ordered in the following quantities:
1.) 100 (would be 1.5)
2.) 200 (would be 1.4)
3.) 305 (would be ???)
The thing here is, I can not use sumproduct() for history values that are different from the standard quantities defined under a.b.c.
Can the sumproduct be changed to also allow checking values which are different from the standard values?