#1 ·
I need to set up a calculator in Excel (it’s technically already done, but I’m doing all the math by hand before typing 😠 in).
It would be organized in rows
A) Name
B) Number of days
C) Daily rate
D) Total price
E) Commission (%)
F) Commission amount
G) Remainder
Basically, I just want it to handle the math. If I plug in the number of days and the daily rate, it should automatically calculate the total price in cells D1, D2, D3, etc. Then, once I manually enter the commission percentage, it should spit out the actual commission amount in F1, F2, F3... and finally subtract that from the total to show the remainder.
How do I actually build this?
Any help—or maybe a link to some Excel formula guides—would be huge.
The only thing I really know how to do is sum a column at the bottom using =SUM(A1:A5).
THANKS 👍
It would be organized in rows
A) Name
B) Number of days
C) Daily rate
D) Total price
E) Commission (%)
F) Commission amount
G) Remainder
Basically, I just want it to handle the math. If I plug in the number of days and the daily rate, it should automatically calculate the total price in cells D1, D2, D3, etc. Then, once I manually enter the commission percentage, it should spit out the actual commission amount in F1, F2, F3... and finally subtract that from the total to show the remainder.
How do I actually build this?
Any help—or maybe a link to some Excel formula guides—would be huge.
The only thing I really know how to do is sum a column at the bottom using =SUM(A1:A5).
THANKS 👍