I need help with the IF function
thanks,
"Bermie66" escreveu:
Thanks. I will try this and see what happens. I will get back to you shortly.
Hello from Bermuda and we are glad Brazil won yesterday. :)
"Marcelo" wrote:
an easier way to do it works is, create a table as
Col A Col B
1 150
2 300
...
17 1695
And use a formula like =if(H8="","",vlookup(h8,A1:B17,2,0))
Hope this helps
Regards from Brazil
Marcelo
"Bermie66" escreveu:
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.
--
|