How to do this formula???

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

Hello,

Sheet 1
A1 Classe1 or Class1a or Class2
A2 Result Value
A3 FORMULA?????
(taking in consideration the option in cell A1 - class1,class1a,class2 -
and the result value in cell A2, how to get the match number from Sheet 2 ?
Exp.:
If A1= Class1
If A2= 1,070.00€
Then A3= 1.00
But IF A1=class1a
Then A3= 3.00

But if A1=class2

Then = 5.00

Sheet 2
A B C
D
Classe 1 Classe 1a Classe 2
1,070.00€ 1.00 3.00 5.00
1,075.00€ 1.40 0.00 0.00
1,080.00€ 1.80 0.00 0.00


Thnak you.

jimmy
 
Back
Top