Tuesday, June 17, 2014

yogi_Find Amount For A Specified Number Based On A Given Table Of Percentages

                                         Google Spreadsheet   Post  #1677
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-18-2014
post by Dapperdw: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2YFdWD6fQ5w)
Finding a Percentage based on amount. Up to 1800 50%, 1801-3600 60%, 3601 on up %70
I need a formula to help me figure out different percentages. 
Anything up to 1800 I need 50%
1801 through 3600 I need 60%
3601 on up I need 70%

So if the number is 6600 I need it to come out to 4080 (1800*.5=900, 1800*.6=1080, 3000*.7=2100)

I am hoping to have one formula to make that all possible.

Thank you so much in advance for your help.