Oct 25 2022 11:16 AM
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
Oct 25 2022 11:22 AM
SolutionOct 25 2022 11:43 AM
Oct 25 2022 11:59 AM
@christellereyes That would be:
=IF(D7>7,C7*70-(D7-7),"x")
"x" will be the result when D7 is not greater than 7.
Oct 25 2022 12:14 PM
Oct 25 2022 10:04 PM
@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.
Oct 25 2022 11:22 AM
Solution