IF.......it's possible....

  • Thread starter Thread starter Zadig Galbaras
  • Start date Start date
Z

Zadig Galbaras

Hi!

I have 9 criterias I have to check, but I can only nest the IF() function
seven times.

It's a matter of two columns A and B

In A the weight
in B the price of freight

kg fare
A B
1 47
3 50
5 55
10 73
15 96
20 120
25 130
30 151
35 174

In let's say C1 I have the weight of the package

In C2 I want the freight to show, accordingly to the table above.

I have sought a solution like this;
=IF(AND(G14>0;C1<$A$1);$B$1;IF(AND(G14>A1;G14<$A$2);$B$2;IF(AND(G14>$A2;G14<
$A$3);$B$3;IF(AND(G14>$A3;G14<$A$4);$B$4;IF(AND(G14>$A4;G14<$A$5);$B$5;"FOC"
)))))

How can I solve this in one formula i C2?
 
One way:

C2: =VLOOKUP(C1, A:B, 2)

I'm not sure what the G15 is doing in your formula...
 
Hi!

Thank you guys! IT WORKED!!!
Vertical lookup, what a new knowledge for me.... :-)))

Thanks a LOT!!
--ZG--
 
Back
Top