Hi VN,
I have a 19 item formula. Someone suggested that I use the VLookUp but that
is not working for me. I see your example below and am wondering if you can
help me with my formula below.
=IF(H8=1,150),IF(H8=2,300),IF(H8=3,450),IF(H8=4,600),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(H8=15,1605),IF(H8=16,1635),IF(H8=17,1665),IF(H8>17,1695),IF(H8=" "," ")
I don't understand how you are saying to make it into two or three formulas.
I am going to work on understanding your explanation while I wait for your
answer to my problem.
Thanks.
Bermie66