IF Statement W/3 Parameters ?

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Or Statement 4
logic doubts 3
Find any cell with a specific format 2
IF Statements 2
INT((MONTH($C$1:$C$7)+2)/3)=$A$2 2
VLook Up Error 2
IS THERE A FORMULA FOR THIS PROBLEM ? 3
Count if statement 3

Top