Feb 17 2022 01:40 AM - edited Feb 17 2022 01:47 AM
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
Feb 17 2022 01:59 AM
Solution@G-Raph I would use a small lookup table as demonstrated in the attached file.
Feb 17 2022 02:08 AM
Feb 17 2022 02:38 AM
@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.
Feb 17 2022 03:04 AM
Feb 17 2022 01:59 AM
Solution@G-Raph I would use a small lookup table as demonstrated in the attached file.