View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CeeCee CeeCee is offline
external usenet poster
 
Posts: 1
Default Can you have to many arguements in a formula

I am atempting to add another arguement to an IF statement. I already have
eight and when I enter the additional statement I get an error

=IF(Q2=351,"Diesel",(IF(Q2=205,"Outside Svcs",(IF(q2=450,"Equip
Rntl",(IF(Q2=540,"Trans",(IF(Q2=541,"Air
Trans",(IF(Q2=542,"Motel",(IF(Q2=543,"Meals",(IF(Q 2=206,"Supply",(IF(Q2=520,"Whse Rntl","Gas")))))))))))))))))

I use this every week and may need to add more. I apply this formula to
over 2,000 rows of information.

Help !!!