Hi
setup a lookup table on a separate sheet (e.g. called 'lookup') with
the following structu
A B
0 15.000
6 18.000
7 21.000
....
16 49.000

now use the following formula
=VLOOKUP(A1,'lookup'!$A$1:$B$20,2)


--
Regards
Frank Kabel
Frankfurt, Germany

"natei6 " schrieb im
Newsbeitrag ...
Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",If
A1=7,"21.000",If A1=8,"24.000",If
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",If
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If
A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help
much
appreciated.

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/