IF function

[wcurtis]

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(F2>650,"7250",IF(F2>600,"6750",IF(F2>550,"6000")))
I have about 15 IF functions I need to nest.

Thanks

 

[Sheeloo]

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

If you more values then try to learn VLOOKUP function.

 

[Elkar]

Try a LOOKUP function instead:

=LOOKUP(F2,{550,600,650},{6000,6750,7250})

HTH
Elkar