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

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



No comments:

Post a Comment