yogi_Set Up A Spreadsheet For Row By Row MultiConditional Output

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #652   Jul 24, 2012     www.energyefficientbuild.com.


user ularnaga said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/XaTChzo5SKs)
Multiple outcome if cell varies

Hello!

I have a calculation and i want to have multiple outcome.

So if the cell P3 has a value of "1 to 49" or "50 to 299" or "300 to 499" or "500 to 9999" then it will use one of the 4 different calculations below. 

P3*PrintSmall49less

P3*PrintSmall50to299
P3*PrintSmall300to499
P3*PrintSmall500to9999

I know how to use "IF" but then i can only use two choices, and not 4 like i want to.

=IF(P3>49;P3* PrintSmall50to299;P3*PrintSmall49less)

Thanks!

----------------------------------------------------------------------------------

following is a solution to the problem ... i have generalized the problem a bit and I have also included an array based formula