Tuesday, July 24, 2012

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

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. 
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)
following is a solution to the problem ... i have generalized the problem a bit and I have also included an array based formula