Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 20, 2013
user post by rcjhutton (http://productforums.google.com/forum/?zx=ypp2d4hsq8dw#!category-topic/docs/spreadsheets/3fFAXnYOvrI)
How to put a set number in a cell depending on the range of another cell
I am not very good with any formulas other then simple adding so hoping someone can help me
Depending on the number in a cell I want a different number in the cell next to it
if column b2 is more the 650 but less then 1299 I need 10% in column c3
if column b2 is more then 1300 but less then 2249 I need 13% in c3
if column b2 is more then 2250 I need 15% in c3
Ok I have kind of sorted it out but for some reason it wont work above 18 ?
This is the formula I am using and I can't see what's wrong, Any suggestions or am I missing something?
The numbers I need are anything below 650 = 0
650 upto 1300 = 10
1300 upto 2250 = 13
2250 upto 3400 = 15