•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make a formula for multiplying one cell by a specific number, depending on specific text in another cell.
Our take
If you find yourself struggling to create dynamic calculations in Excel, you're not alone. Many users seek to automate their spreadsheets to save time and reduce errors. By using a simple formula, you can multiply values based on specific text in another cell. For instance, if cell E15 contains the number 2, you can easily multiply the accounting value in E12 by 1.6. Read on to discover how to construct this versatile formula, empowering your spreadsheet skills and enhancing your productivity.
Hi! I'm working on a sheet for work and need some help, as I have little to no excel experience. I'm trying to create a formula where, if the number 2 is in e15, multiply e12($ accounting value) by 1.6, if the numbers 3 is in e15, multiply e12 by 2.2, and so on and so on, all within a single cell. Is there a way to do this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Applying multiple row formulas to one cellGreetings, I have a list of bills with increases and some with percentage increases I am trying to write the proper formula for. I believe it would be a nested IF function. For example, A1 = title, B1 would be current amount, C1 would be dollar increase, D1 would be percentage increase, E1 would be the increase amount, and F1 would be the total of E1 + B1. How would I write the formula for E1 to calculate based off cells C1 or D1 either having an amount of be blank? So far I have figured out IF(C1="",0,C1+B1) but can't figure out how to also have D1 also apply same rules, except multiplying a percentage. I know I could do this a more manual way, but I have a college degree that used a bit of Excel and am always trying to use it to keep skills sharp and learn things I can't figure out, on my own. Appreciate any input! submitted by /u/Zealousideal_Bag8757 [link] [comments]
- Looking for a better way to do a multplication formulaGoing to attempt to word this where it is understandable. Right now I am having to manually type in the cell number into my formula for each area I would need it. For example =A35*2 written in cell A37 and having the *2 number two spaces above. Do I need to keep writing the cell numbers over and over in each space or is there an option to list *two cells above* multiplied by 2? Photo of what I am trying to accomplish. The values would obviously be different each use of this function. https://preview.redd.it/fnmp1dy6dj0h1.png?width=414&format=png&auto=webp&s=fdd86045c131652b9f2f79ec52bfcff8fdf7d690 submitted by /u/lilwigglyyak [link] [comments]
- Formula to mulitiply all values in one column based on the criteria of another.I'm looking for a formula that will mulitiply all values in one column based on the criteria of another. So on a data sheet; Column A contains text, Column B contrains a value. Essentially I'm thinking like the SUMIF Formula, but instead of adding all the values, it multiplys all the values. Thank you. submitted by /u/HumanScar9638 [link] [comments]
- How to Change Values Based on another Cell's Values?So basically, I'm trying to figure out how to make a cell have a certain text value depending on the number value of another cell. An example would be if B2 is less than 10, the text should say "hi", if it's between 11 and 20, it should say "hello", and if its above 21, it should say "bye". I've already tried IF statements within each other, but it wouldn't work properly. Any ideas or suggestions would be greatly appreciated. Edit: I found the answer, thanks to everyone who commented :) submitted by /u/VaderisPotater [link] [comments]