Can this be made smaller?

F

fivermsg

i would like this to be smaller.. or if not can someone tell me why i
can't add to it? i tried to continue with the same thing in the next
stage but it won't let me add anymore to it..

=IF(E10<100%,"0%-99.99%",IF(E10<125%,"100%-124.99%",IF(E10<150%,"125%-149.99%",IF(E10<175%,"150%-174.99%",IF(E10<200%,"175%-199.99%",IF(E10<225%,"200%-224.99%",IF(E10<250%,"225%-249.99%",IF(E10<275%,"250%-274.99%"))))))))
 
J

John Eppley

Perhaps the VLOOKUP function can work for you. Simply create a table of your
known values, then reference the table.

Hope this helps

John
 
Top