Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default IF function

Try Lookup like this
=LOOKUP(A1+49,{0,50,100,150,200,250,300,350,400,45 0,500,550,600,650})

If you more values then try to learn VLOOKUP function.

"wcurtis" wrote:

I have a spreadsheet that will use more IF functions than allowed. Is there
away around this or another function that I can use. Here is an example but,
it is much longer when it is completed.
=IF(F2650,"7250",IF(F2600,"6750",IF(F2550,"6000 ")))
I have about 15 IF functions I need to nest.

Thanks