Discussion:
Google Sheets - help with negative numbers
Add Reply
d***@hellbenderhd.com
2018-02-06 14:38:11 UTC
Reply
Permalink
Raw Message
I am working on a payroll sheet. My employees have a base daily rate, and commission. They are paid whichever amount is greater. When subtracting the daily rate from the commission, there is a negative number if the employee did not make enough commission. I need the formula to make that negative number show in the cell as the base daily rate.
Barry Schwarz
2018-02-06 16:42:18 UTC
Reply
Permalink
Raw Message
Post by d***@hellbenderhd.com
I am working on a payroll sheet. My employees have a base daily rate, and commission. They are paid whichever amount is greater. When subtracting the daily rate from the commission, there is a negative number if the employee did not make enough commission. I need the formula to make that negative number show in the cell as the base daily rate.
If rate is 100 and commission is 50, you want to change the rate to
-50?

if commission < rate then rate = commission - rate;

How do you then compute the amount to pay since commission is now more
that daily rate? Or do you make this change after computing amount to
pay? If so, why?
--
Remove del for email
Loading...