SOLVED

New Contributor

# 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

5 Replies
best response confirmed by christellereyes (New Contributor)
Solution

# Re: editing microsoft excel online

@christellereyes

In C11 enter this formula:

=IF(D11>350000,250,"")

# Re: editing microsoft excel online

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.

# Re: editing microsoft excel online

@christellereyes That would be:

=IF(D7>7,C7*70-(D7-7),"x")

"x" will be the result when D7 is not greater than 7.

# Re: editing microsoft excel online

I tried this one but, it's not working. The value in c7 will reflect as x

# Re: editing microsoft excel online

@christellereyes Can you upload a screenshot* of the relevant part of your schedule and indicate the outcome you expect?

*create a screenshot, save it on your local machine. When replying, press the photo camera symbol (see toolbar in the top of the Message editor) and follow the instructions.