IF function
 

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

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

IF function
 

Try a LOOKUP function instead:

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

HTH
Elkar


"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