Thank Beege. I am going to try this as well.

"Beege" wrote:

"Bermie66" wrote in message
...
Hi,
I am trying to use the IF function but it may be the wrong one. Below is
my
formula but it keeps coming up #VALUE!. What am I doing wrong? Any
assistance provided would be helpful.

=IF(H8=1,150),IF(H8=2,300),IF(H8=3,450),IF(H8=4,60 0),IF(H8=5,750),IF(H8=6,900),IF(H8=7,1015),IF(H8=8 ,1130),IF(H8=9,1335),IF(H8=10,1385),IF(H8=11,1435) ,IF(H8=12,1485),IF(H8=13,1525),IF(H8=14,1565),IF(H 8=15,1605),IF(H8=16,1635),IF(H8=17,1665),IF(H817, 1695),IF(H8="
"," ")

Thanks much.
--

=IF(AND(H8<17,H80),LOOKUP(H8,{1,2,3,4,5,6,7,8,9,1 0,11,12,13,14,15,16},{150,300,450,600,750,900,1015 ,1130,1335,1385,1435,1485,1525,1565,1605,1635,1665 }),IF(OR(H8="",H8=0),"",1695))