How to make a mathematical formula operate in the same cell in which I input a number?
Our take
I have students doing an exam of 53 questions.
When they tell me the score, eg. 46 out of 53 questions correct, I want to put that number into a cell, and then have it automatically convert it to a percentage in that same cell. Is there a way to do this in the same cell into which I input the number?
example. in Cell B3.
I put in the number 45.
Excel makes a calculation of "45 divided by 53 multiplied by 100" and puts the result as a percentage in the same cell (B3) where I input the value 45, in this case 86.79%.
I know how to do this using more than one cell, where the formula is put in to cell B4, which would tell excel to take the value of cell B3, apply the formula, and get the result in cell B4. I am trying to find out if I can do it inside the cell without additional cells and external cell references.
Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Problem with assessing scoresHello, could someone help me, I don't know how to write this formula. You want to assess your score. If you have 95 then write in a cell 5 (because 5-> (90, 100]) or 82 then write 4 (because 4->(80, 90]. So for example in one side you have a column full of scores next to it you want to write which mark it belongs to. Ive tried with =if function but I think I overcomplicated it. Thanks in advance submitted by /u/Particular_Salad3723 [link] [comments]
- Need formula to be just the numberI can't seem to get the formula to go away and just be the answer. I have tried copying and pasting with special values, but that also did not work. I am new to Excel and do not fully understand it. https://preview.redd.it/nqjt1a1g5qxg1.png?width=826&format=png&auto=webp&s=5a7942502925fdfc3f189d62218a71622349e5c8 https://preview.redd.it/xht99d7i5qxg1.png?width=680&format=png&auto=webp&s=e6c363ce08480fcdaa6c96ae3f7d834ae9a2b8e2 submitted by /u/graveyard-bones [link] [comments]
- Formula to generate $ amount of another cellExcel Noob here, I need help with formula that generates a dollar amount based on another cell using a percentage. I do not want end result to be a percentage. Ex: person A has a salary of $100,000 and works on 3 projects at a 40-30-30 split Desired result is 3 cells that contains dollar amounts based on these percentages. I am using excel on windows 11 - Microsoft Office 365 submitted by /u/Banana_Hammock84 [link] [comments]
- cell not calculating correctlywhat i am trying to accomplish, and i have written and used this formula many times, but not recently, i dont have an old sheet to copy it from, i cant figure out why its not calculating correctily. i need H3 or I3 to show a total percentage, with final value of 1 or 100% of all the rows in F3. i've tried the formula in differt configs, tweaked, adjusted and just can t get it. see pic below for formula im using in H column. i set it up in a few columns so i can test/prove different versions at the same time. i know its something minor i am missing. just need one box, H3 to display total percentage of column F. the formula in I3 works but stops calculating after a certain point, H3 and J3 are both just a mess. any suggestions? working in excel desktop https://preview.redd.it/nshc5dm377ug1.png?width=1153&format=png&auto=webp&s=a618b8a383a23830a11c548aa5d98f0ccfe9e670 submitted by /u/AcidRayn666 [link] [comments]