View Single Post
  #1   Report Post  
Kris-GMA
 
Posts: n/a
Default 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