Price dinamic structure

[traga2whiskys]

Good Morning

I would like to do something like this in the same space:

If A1 between 0 and 10 then * 50
if A1 between 10,01 and 50 then * 35
If A1 between 50,01 and 100 then * 15

So if A1 was 35,56 the result should be (35,56*35) 1244,6. If 8,9 then result 445.

Is this possible in Excel???

Thank you very much in advance
Traga2whiskys

[zbor]

That.. And much more

Try this:

=A1*LOOKUP(A1;{0;10;50};{50;35;15})

(change ; to , if needed)

[traga2whiskys]

If A1 between 0,01€ and 3,00€ then multiply A1 by 3,00
if A1 between 3,01 € and 6,00 € then multiply A1 by2,95
if A1 between 6,01 € and 12,00 € then multiply A1 by 2,75
if A1 between 12,01 € and 20,00 € then multiply A1 by2,95


Thank you for your prompt answer, but i was lost while i was trying, thus i gave me error. Above you may find the real example of what i need, this is a table for pricing markup wines for a restaurant. All this formula have to be in same cell.

Zbor, if you can help me, i am very thankfull.

Cheers

[zbor]

Look here:

[traga2whiskys]

Where exactly?

[traga2whiskys]

Zbor

Thank you very much... i figure out what was wrong!!!

Here the complete set... Changed Lookup into PROC (portuguese version)

=PROC(C5;{0,01;3;6;12;20;40;60;80;100;200};{3;2,95;2,75;2,85;2,65;2,45;2,25;2;1,9;1,75})

So now if you now the secret of marking up the wines in restaurants!!! At least the ones i passed by!!

Thank you very much
Regards