Forum Discussion
Robert1966
Sep 01, 2020Copper Contributor
Require a formula for Excel Spreadsheet
Hi All, Can anyone give us a formula to use on Excel for the following; First 500 Items paid at $ 0.80 next 500 Items paid at $1.00 next 500 Items paid at $1.20 rest paid at $1.40 So if I have ...
Riny_van_Eekelen
Sep 01, 2020Platinum Contributor
Robert1966 Created a small model in the attached file, using some named ranges to avoid absolute references.