please find the sample attached.
Thanks guys
please find the sample attached.
Thanks guys
Last edited by RubenC; 05-16-2017 at 05:40 AM. Reason: Adding a sample
It would help if you attached a sample Excel workbook, so that we can see what formulae you are using at present.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Pete
Which formulas and what cells that formulars are in?
Quang PT
sample as been attached thanks !
See attached:
in A2
=MIN(SUM($C$2:C2),400)
Copy down
in C2
=B2*0.04 (fixed)
in C3
=IF($A2+($B3*0.04)>400,400-$A2,$B3*0.04)
copy down
in D2
=$B2-$C2
Many thanks !
You are a star
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
And thank you for the rep.
Thanks for the rep from me, as well, though I didn't do very much.
The reason I asked you to attach a sample workbook is that your image does not show which columns and rows the data is in, and we can't work with a picture anyway - we would have to make assumptions about where your data is located, AND type the data into a workbook before we could start to play about with some formulae (which many contributors are reluctant to do, given that you already have an Excel file from which you took the image). For future reference, you will tend to get a quicker answer (and a more accurate one) if you attach a sample Excel file, rather than a picture of one.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks