Sorry for the hassle, the formula provided did the trick.. Marking this as solved.
Sorry for the hassle, the formula provided did the trick.. Marking this as solved.
Last edited by RaMubara; 01-27-2017 at 02:52 AM.
pls attach a sample excel file with desired result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You dont give much to go not, but this should form the basis of your calc...
if(or(xx>300,yy>50000),.05,if(or(xx>=150,yy>20000),.04,if(or(xx>=70,yy>10000),.03,if(or(xx>=30,yy>5000),.02,1))))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry all...not sure what the deal is but when I click on attachment option in a reply post, it doesn't open anything up for me to upload an example. Below is a screenshot of what I am trying to do. I'd like to have percentage value in M3 automatically change based on what is entered in J (qty) or L (total value).
2017-01-26_22-08-55.jpg
2017-01-26_22-39-30.jpg
Last edited by RaMubara; 01-27-2017 at 02:40 AM.
-----------------------------------
Last edited by RaMubara; 01-27-2017 at 02:28 AM.
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Thanks much! That did the trick.
Really appreciate it as always!
Ummm OK, what did what trick lol?
Did you figure out your problem?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks