Forum Discussion
Solved
editing microsoft excel online
Hi, I'm creating a spreadsheet for payroll and I want to ask on a formula for example
if d11 is greater than $350,000 then c11 would reflect as $250
- That was perfect! thank you so much, I have yet to learn these formulas. Can I some more? this is a bit complicated for example
if d7 is greater that 7 then c7 should multiply $70 by the number in d7 minus 7
the explanation is because the employee will get a comission for every signed contract that is more than 7. If the number of signed contracts will be 20 then the commission willl be $70 multiplied by 13.christellereyes That would be:
=IF(D7>7,C7*70-(D7-7),"x")
"x" will be the result when D7 is not greater than 7.
