Monday, May 21, 2012

yogi_Choose Answer Based On Multiple Set of Choices

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #548    May 20, 2012

user Bronxand said:
Another IF Qiestion.
So i'm trying to get a box to show a value in cell (B10) depending on what number is punched entered into a cell (F5)
F5= Autopay, B10= .15
30, .05
60, .10
90, .18
150, .25
240, .30
and 0 for any other value
I've been working with this formula
=IF(F5="Autopay", .15,IF(F5="30", .05,IF(F5="60", .10,IF(F5="90", .18,IF(F5="150", .25,IF(F5="240", .30, 0)))))) 
So when i punch in Autopay into F5, the correct value of .15 shows up in B10, but if i plug in 30, 60, 90, 150, or 240, I get zero. 
I noticed that what ever is the last number of the formula, then that's the value that comes up when 30, 60, 90, 150, 240 is punched in. 
not to sure where to go from here, any suggestions?
in the following I present couple of different solution to the problems