# Too Many Arguments In IF Function

• 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.

• Re: Too Many Arguments

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

• Re: Too Many Arguments

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

• Re: Too Many Arguments

Then just use a Vlookup.

• Re: Too Many Arguments

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

i do i set it up?

• 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]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!