Require a formula for Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1624381%22%20slang%3D%22en-US%22%3ERequire%20a%20formula%20for%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624381%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3ECan%20anyone%20give%20us%20a%20formula%20to%20use%20on%20Excel%20for%20the%20following%3B%3C%2FP%3E%3CP%3EFirst%20500%20Items%20paid%20at%20%24%200.80%3C%2FP%3E%3CP%3Enext%20500%20Items%20paid%20at%20%241.00%3C%2FP%3E%3CP%3Enext%20500%20Items%20paid%20at%20%241.20%3C%2FP%3E%3CP%3Erest%20paid%20at%20%241.40%3C%2FP%3E%3CP%3ESo%20if%20I%20have%20743%20Items%2C%20I%20would%20be%20paid%20%24643.00%20and%20if%20I%20had%202054%20items%2C%20I%20would%20be%20paid%20%242%2C415.60.%3C%2FP%3E%3CP%3EWhat%20I'm%20looking%20at%20is%20to%20put%20the%20amount%20of%20Items%20into%20a%20cell%20to%20give%20me%20the%20correct%20dollar%20figure.%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3ERobert1966%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1624381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1624611%22%20slang%3D%22en-US%22%3ERe%3A%20Require%20a%20formula%20for%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F777675%22%20target%3D%22_blank%22%3E%40Robert1966%3C%2FA%3E%26nbsp%3BCreated%20a%20small%20model%20in%20the%20attached%20file%2C%20using%20some%20named%20ranges%20to%20avoid%20absolute%20references.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 743 Items, I would be paid $643.00 and if I had 2054 items, I would be paid $2,415.60.

What I'm looking at is to put the amount of Items into a cell to give me the correct dollar figure.

Cheers,

Robert1966

1 Reply
Highlighted

@Robert1966 Created a small model in the attached file, using some named ranges to avoid absolute references.