•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula to generate $ amount of another cell
Our take
If you're looking to calculate dollar amounts based on a salary and specific percentage splits in Excel, you're in the right place. In this scenario, you want to distribute a $100,000 salary across three projects with allocations of 40%, 30%, and 30%. By using straightforward formulas, you can easily generate the desired dollar amounts for each project without displaying percentages.
Excel 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
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#cloud-based spreadsheet applications#AI formula generation techniques#rows.com#formula generator#financial modeling with spreadsheets#Excel#formula#dollar amount#percentage#salary#projects#split#cells#Windows 11#Microsoft Office 365#generate#end result