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
|