IF function

  • Thread starter Thread starter wcurtis
  • Start date Start date
W

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
 
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.
 
Back
Top