SOLVED

New Contributor

# If function with quantities (range) [in french fonction SI]

Hi,

I need to Calculate prices depending on quantities with variable prices depending on quantity input.

Cell C218 is the quanty that the user needs to fill

Cell G218 is the price that needs to be calculated (the If function) depending on what the user inputs on C218

if C218 is empty then G218 should show 0

If C218 is between 1-4 then G218 should equal C218 * S217 [S217 contains a figure ie \$1000)

if C218 is between 5-9 then G218 should equal C218 * S218 [S218 would be \$800 for instance)

if C218 is between 10-15 then G218 should equal C218 * S219 [S219 would be \$700 for instance)

if C218 is 50 or more then G218 should equal C218 * S220 [S220 = \$500 for instance)

You get the idea

Thank

4 Replies
best response confirmed by G-Raph (New Contributor)
Solution

# Re: If function with quantities (range) [in french fonction SI]

@G-Raph I would use a small lookup table as demonstrated in the attached file.

# Re: If function with quantities (range) [in french fonction SI]

Thanks. That looks much easier.
Quick question, how do you setup the lower & price ranges/tables ? (noob question I know)

# Re: If function with quantities (range) [in french fonction SI]

@G-Raph Just type them anywhere. doesn't have to be on the same sheet.  The link below takes you to the MS help page on Named Ranges. I can't really explain it any better myself.

# Re: If function with quantities (range) [in french fonction SI]

Perfect, that was easy. Thanks so much.