Forum Discussion

Copper Contributor

Feb 17, 2022

Solved

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...

excel

Formulas and Functions

Riny_van_Eekelen
Feb 17, 2022
G-Raph I would use a small lookup table as demonstrated in the attached file.
g-raph.xlsx9 KB

Riny_van_Eekelen

Platinum Contributor

Feb 17, 2022

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

g-raph.xlsx9 KB

G-Raph

Copper Contributor

Feb 17, 2022

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

Riny_van_Eekelen
Platinum Contributor
Feb 17, 2022
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.
https://support.microsoft.com/en-us/office/create-a-named-range-from-selected-cells-in-a-worksheet-fd8905ed-1130-4cca-9bb0-ad02b7e594fd
- G-Raph
  Copper Contributor
  Feb 17, 2022
  Perfect, that was easy. Thanks so much.