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
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.
Thank you so much in advance for your help.
Daniel
-------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment