LinkBack URL
About LinkBacks
Hi,
I believe I need to use an If formula to create a calculation. My example is as below.
If 100 = 6% and 50 = 3% - how do I create a formula to calculate the percentage totals?
Hi,
I believe I need to use an If formula to create a calculation. My example is as below.
If 100 = 6% and 50 = 3% - how do I create a formula to calculate the percentage totals?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
If your value is in J2...
=J2/100*0.06
or just =J2*0.0006
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
I have added an attachment for demonstration. Hopefully this makes my request a little clearer.
Last edited by AnitaAus.; 06-02-2017 at 01:20 AM.
As given before
in B3
=$B$1/100*0.06
=MIN(6%,6%*B1/100)
Try this
in your sheet calculations option in in manual mode change it to automatic if needed
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Siva,
I have attempted the formula as suggested, if I change the amount in cell b1 in example shown it doesn't adjust the percentage? I have added another attachment.
What I'm hoping for is that if I change the amount in cell B1 to for example 50 it will recalculate to 3%
Did you even try my suggestion? It gives you exactly what you asked for
Actually, so does Siva's
Hi,
The formula works to complete calculation, however when I change the amount in the cell (J2) it doesn't update to the new percentage?
Yes, it does. Check to make sure your calcs are set to AutoOriginally Posted by AnitaAus.
Sorry I have been trying both, but I don't know if it's me but same thing, updating the amount does not make it recalculate
Ok, now I'm probably sound like a real beginner, but how do I check that?
Have you done as Ford suggested and checked that you have not set calculations to manual?
Formulas | Calculation options.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
select the Formulas tab/Calculation/Calc Option, make sure Auto is selected
hmm just had another thought.
How is B2 formatted?
Put this in an empty cell somewhere and tell me what it gives you...
=isnumber(B1)
I figured it out Thank you Everyone! Auto - I never knew about that - learn something all the time!
That catches many people, even old hands.
Happy to help, glad you got it resolved
If you are familiar with VBA, then the first line of this code might do the same “Auto on” thing.
The other lines don’t usually do any harm either. This simple codes often brings things back into life that appear “dead”
Please Login or Register to view this content.
Alan
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks