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
|