Multiple variables to calculate a value

[cruisinto]

I am looking for a syntax to help us ask a question with three variables

As an example
If
Blade size = 114 (only 3 blade size choices)
and
the Panel Size is between 500 and 700 ( This will also be dependant on the blade size)
and
the tilt bar is clearview (Three choices)
then
the result will be x = 182

The answers will depend on the above variables: 154, 159, 179, 177, 182 and 202


Screenshot 2014-06-26 14.21.41.pngScreenshot 2014-06-26 14.23.53.pngScreenshot 2014-06-26 14.26.11.png

[FDibbins]

Hi and welcome to the forum

Please upload a sample of your workbook, not a picture of your data.
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[cruisinto]

pricing calculator.xlsxthanks FDibbins for your response.

I have attached a spreadsheet which gives two scenarios I am working with to solve the pricing syntax I am trying to create with.

Scenario 1: I am using dependant lists and can't get my head around the third dependancy list

Scenario 2: trying to use the "If" function for multiple variables but I haven't been able to get any together to finish the answer

Scenario 3: Hoping you might be able to help me come up with a solution

See attached spreadsheet

pricing calculator.xlsx

[Saarang84]

Hi,

Here's one way of doing it... Refer workbook attached. Is this what you need?