Too Many Arguments In IF Function

sac1973 · Feb 14th 2008

i hope i'm using the correct terminology...

i have 18 arguements that i want to enter using the "if" formula. however, after entering the data i get a message stating that i have too many arguments.

here is the data that i'm trying to enter:
ALLOY DENSITY
A20 0.291
2205 0.285
254SMO 0.284
A200 0.321
A400 0.319
A600 0.304
A625 0.303
A800HT 0.287
A825 0.294
C276 0.323
C22 0.290
A286 0.289
I718 0.296

i start the formula as follows:
=IF(B7=20,".291",IF(B7=2205,".285",IF(B7=254,".284",.............
i drop the letters from column "b" because i stopped getting error messages when i took them out.

turtle44 · Feb 14th 2008

Re: Too Many Arguments

You can only nest 7 If functions. What are you trying to do exactly?

sac1973 · Feb 14th 2008

Re: Too Many Arguments

when an individual inputs an item from column a, column b automatically populates

turtle44 · Feb 14th 2008

Re: Too Many Arguments

Then just use a Vlookup.

sac1973 · Feb 14th 2008

Re: Too Many Arguments

i sure this is going to be redundant, but could you expound...

i do i set it up?

turtle44 · Feb 14th 2008

Re: Too Many Arguments

If you table data is in D1:E14, then enter this formula in B1 and copy down.
[bfn]=VLOOKUP(A1,$D$1:$E$14,2,FALSE)[/bfn]
Or, if you don't want the error values, something like this:
[bfn]=IF(COUNTIF($D$1:$D$14,A1)=0,"",VLOOKUP(A1,$D$1:$E$14,2,FALSE))[/bfn]

Dave Hawley · Feb 15th 2008

Re: Too Many Arguments

Hover over Formula and read
NESTED IF LIMITATION

Too Many Arguments In IF Function

Participate now!

Share