IF Statement W/3 Parameters ?
 

Hello

I am looking for a function that will test 2 parameters, and if neither is
true, then default to a specific answer.

My spreadsheet has the "F" column importing the words film, vellum or bond.
I would like the "A" column to show for "film" the number 388; for "vellum"
the number 385, and any other words (should only be "bond") the number 382.

I got it to work putting the number 388 for when the word is Film, and
defaulting to 382 for any other occassion. What I can't get, is for it to
check for one more parameter (that being vellum = 385) before defaulting to
382 for bond.

Any help you can offer would be much appreciated.

Thank you

try a nested if
=if(A1="Vellum",385,if(A1="Film",388,382))
you can go up to 7 nested levels in if statements.

"Kris-GMA" wrote:

Hello

I am looking for a function that will test 2 parameters, and if neither is
true, then default to a specific answer.

My spreadsheet has the "F" column importing the words film, vellum or bond.
I would like the "A" column to show for "film" the number 388; for "vellum"
the number 385, and any other words (should only be "bond") the number 382.

I got it to work putting the number 388 for when the word is Film, and
defaulting to 382 for any other occassion. What I can't get, is for it to
check for one more parameter (that being vellum = 385) before defaulting to
382 for bond.

Any help you can offer would be much appreciated.

Thank you