Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : IF Statement in VB/Excel

[byteventures]

I have a statement that requires 10 IFs, and Excel can only handle a maximum of 7. I will need to use VB, but I think the code might be really long.

Currently I have a formula that looks like this:
=IF(A9>20<25,F9,IF(A9>26<31,F10,IF(etc...)

This IF statement needs to run for cells A9 to A40, and there are 10 IFs to validate each cell. Does anyone know an easy way to code this in VB?

Thanks in advance for all of your help!

[aritrim]

Have you tried a Case statement?

select case
case A < X and A > Y
........
........
case A < Z and A > W
........
........
end select