There's a quiet elegance in the question at the heart of this post. A user with a salary, three projects, and a 40-30-30 split just wants the dollar amounts to appear in three separate cells. No percentages. No confusion. Just clean, usable numbers. That's it. And that's exactly why this simple request matters.
The formula itself is almost trivial: multiply the salary cell by each percentage cell. If A1 holds $100,000 and B1, B2, and B3 hold 40%, 30%, and 30%, then =$A$1*B1 gives you $40,000, and so on. The key is remembering that Excel treats percentages as decimal fractions under the hood. So 40% is really 0.4, and the multiplication works without any extra conversion. The user doesn't need a complex array formula or a pivot table. They need one straightforward equation dragged across three cells, with the salary reference locked using dollar signs. That's the whole trick.
What makes this post worth pausing on is not the mechanics, but the mindset. The user identifies as a self-described "Excel Noob" and explicitly states what they don't want: a percentage result. That's a person who has been burned before, likely by formatting issues or by assuming the tool would interpret their intent. They aren't asking for a lecture on cell references or an explanation of relative versus absolute addressing. They want the outcome, and they want it to look like money. That's a reasonable demand, and it's one that modern spreadsheet tools should meet without friction.
For anyone reading this who's ever felt stuck in a similar loop, the takeaway is simple: start with the data you have, not the tool's defaults. The salary cell holds a number. The percentage cells hold numbers with a percent format. Multiply them, and you get a number that you can then format as currency. The formula doesn't care about your comfort level; it cares about the values you give it. So lock that salary cell with dollar signs, write the multiplication once, and drag it across. Then format the results as currency, and you're done. No macros, no scripting, no advanced functions. Just a clear path from a question to an answer.
The real insight here is that most spreadsheet frustration comes from a mismatch between what users see and what the software assumes they want. The fix isn't more complexity. It's clarity in the formula and confidence in the output. If you're the person asking this question, you're already ahead of the curve by knowing what you don't want. Now go get those dollar amounts. They're one multiplication away.