Hi
I'm making a budget sheet and I need help creating/finding the right formular. It's really just a luxury-problem, or me being lazy, but it would decrease the amount of hours I need in front of my computer.
So I want a cell to multiply the value in that cell by 125. So whenever I write, say 5, into the cell, it would multiply 5 by 125. How can I create that function?
Mikkelno
Last edited by mikkelno; 05-10-2017 at 08:22 AM.
In cell a1 put 125Originally Posted by mikkelno
In cell a2 put 5
In cell A3 write:
=Sum(a1*a2)
and press enter
If myself or others have helped, please add to our reputation by pressing the 'Star' icon below this.
Thanks for the reply!
That's not what I am looking for though. I want cell A1 to multiply whatever number I write in A1 by 125 and then show me the total in A1. Is that possible?
Not through a formula it isn't.
Why is this not okay though? Why do you only want to use 1 cell?
HI
No it is not possible at this throw a circular reference .
Provide the sample data sheet we shall find the best method which will fit your requirement
Punnam
Simple laziness. I'm running my own massage clinic and I'm trying to save time by not writing down every client I've had, by just counting the number of times I've done a 30 or 60 minute massage throughout a week.
Use a simple spreadsheet with column "A" being occurences and column "B" being duration.
Then in column "C" you would use A1*B1 - dragged down
Not possible.PHP Code:That's not what I am looking for though. I want cell A1 to multiply whatever number I write in A1 by 125 and then show me the total in A1. Is that possible?
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I've attached my file in my OP.
Sheet 3 is where I want my function to be. D4, D5, D6, D7, D8, D9, D10 and D11 are the cells where I want my function to be.
As others have stated, it is not possible with Formulas. You can use VBA to convert do this. I assume you will want this to happen in D4:O11
Enter this code into the worksheet (Right click on the tab>View code)I set the macro up that it works when entering individual data. If you paste a range into your sheet, it will not multiply it.
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you, that works very well!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks