more than 7 IF statement

can any one help to write multiple (more than 7) if statement, want to choose a math for A1 from 8 choices C1:C8   =IF(A1<=B1,C1,IF(A1<=B2,C2,IF(A1<=B3,C3,IF(A1<=B4,C4,IF(A1<=B5,C5,IF(A1<=B6,C6,IF(A1<=B7,C7,&IF(A1<=B8,C8,0). I wanted only choose on result but with &IF it choose a result form C1:C7 plus C8. if I change &IF to +IF it just add the two result together.

Comments
There are 9 comments. Login or register to view them.

Try a VLOOKUP

George Attazder |
George Attazder's picture

And if you have

paulwakefield1 |

Thanks Paul

George Attazder |
George Attazder's picture

:-)

paulwakefield1 |

Personally

Richard Willis |
Richard Willis's picture

Memories!

davidwinch |
davidwinch's picture

Error!...

George Attazder |
George Attazder's picture

Lotus 123

Red Leader |
Red Leader's picture

I still use Lotus 123

paulwakefield1 |