I need help with the IF function

[Guest]

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,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=" "," ")

Thanks much.
--

 

[Guest]

Hi Bernie,

Excel support just 7 ifs in a formula

hope this helps
regards from Brazil
Marcelo

"Bermie66" escreveu:

 

[Guest]

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:

 

[Beege]

Bermie,

Try the Lookup function instead. If can only be used 7 times.

Beege

 

[Guest]

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.

 

[Beege]

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,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="
"," ")

Thanks much.
--

=IF(AND(H8<17,H8>0),LOOKUP(H8,{1,2,3,4,5,6,7,8,9,10,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))

 

[Guest]

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.

 

[Guest]

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

=IF(AND(H8<17,H8>0),LOOKUP(H8,{1,2,3,4,5,6,7,8,9,10,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))

 

[Guest]

It worked. Thanks very much.

=IF(AND(H8<17,H8>0),LOOKUP(H8,{1,2,3,4,5,6,7,8,9,10,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))

 

[Beege]

Glad to help, thanks for the feedback

Beege

It worked. Thanks very much.