Forum Discussion

Copper Contributor

Dec 03, 2017

Solved

if formula nested

Hello, I try to transcribe these conditions with an IF but an error message appears that I don't understand PA PN 0,01<PA<0,99 =(PA*2)+7 1<=PA<9,99 =(PA*2)+9 10...

Formulas & Functions

Need Help

Detlef_Lewin

Dec 03, 2017

Yamina,

two alternatives.

0,02	7,04	7,04
12,43	35,86	35,86
24,56	62,12	62,12
36	76	76
41,56	81,56	81,56



	0,01	2	7
	1	2	9
	10	2	11
	20	2	13
	30	1	40

=IF(A2>=30,A2+40,A2*2+5+MATCH(A2,$B$10:$B$14,1)*2)

=A2*LOOKUP(A2,$B$10:$B$14,$C$10:$C$14)+LOOKUP(A2,$B$10:$B$14,$D$10:$D$14)

Detlef_Lewin

Silver Contributor

Dec 03, 2017

Yamina,

two alternatives.

0,02	7,04	7,04
12,43	35,86	35,86
24,56	62,12	62,12
36	76	76
41,56	81,56	81,56



	0,01	2	7
	1	2	9
	10	2	11
	20	2	13
	30	1	40

=IF(A2>=30,A2+40,A2*2+5+MATCH(A2,$B$10:$B$14,1)*2)

=A2*LOOKUP(A2,$B$10:$B$14,$C$10:$C$14)+LOOKUP(A2,$B$10:$B$14,$D$10:$D$14)

Yamina Azri
Copper Contributor
Dec 03, 2017
Thank you for you reply, but I try the two formulas and no results

PA PN
6 #REF!
Here the formula =A2*RECHERCHEV(A2;$B$10:$B$14;$C$10:$C$14)+RECHERCHEV(A2;$B$10:$B$14;$D$10:$D$14)
12,43
24,56
36
41,56

0,01 2 7
1 2 9
10 2 11
20 2 13
30 1 40
- Yamina Azri
  Copper Contributor
  Dec 03, 2017
  Finally I find my error in the first formula I change MATCH by EQUIV in french and it works.
  thank you very much.