Hello,
Making a new spreadsheet.
Would you please let me know how I can make a spreadsheet do this.
Nothing that I have tried is working so far.
A = $ 100
B = takes 100 % of the amount in A up to $ 40
C = takes 100 % of the amount in A up to $ 40
D = takes 100 % of the amount in A up to $ 20
E = takes 100 % of the amount in A up to $ 20 but does not post a value in the cell as there is nothing left of the $ 100.
etc.
Thank you,
Richard Todd
Last edited by RVT; 11-08-2013 at 03:47 PM.
Please see the attached file
put your values in row 1:
A1: 100
B1: 40
C1: 40
D1: 20
E1: 20
in A1: 0
in B2: =IF($A$1>=SUM($B$2:B$2),IF($A$1-SUM($B$2:B$2)>=B$1,B1,$A$1-SUM($B$2:B$2)),0)
and copy across to E2
Hello yudlugar,
What I am getting in the cells B etc is a value of 0.
Thank you,
Richard
Hello aganesan99,
That works for the percentage but is there a way to limit the amount that is taken out in a cell?
Thank you,
Richard
Hi Richard,
Sorry for late reply.
I got it.
Please see the attached file.
Last edited by aganesan99; 11-11-2013 at 05:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks