|
I need help with the IF function
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. -- |
I need help with the IF function
Hi Bernie,
Excel support just 7 ifs in a formula 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. -- |
I need help with the IF function
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. -- |
I need help with the IF function
Bermie,
Try the Lookup function instead. If can only be used 7 times. Beege "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. -- |
I need help with the IF function
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. -- |
I need help with the IF function
"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)) |
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. -- |
I need help with the IF function
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)) |
I need help with the IF function
It worked. Thanks very much.
"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)) |
I need help with the IF function
Glad to help, thanks for the feedback Beege "Bermie66" wrote in message ... It worked. Thanks very much. "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)) |
| All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com