Jan 17 2022 09:11 AM
Hi, can you please tell me the formula to calculate the following.
If the cell value is 170 or less than 170 I want the answer to be 0. and if the cell is greater than 170 I want 170 deducted from the cell amount and the difference reported.
Can you kindly advise?
Thank you in advance
Niki
Jan 17 2022 09:16 AM
Jan 18 2022 01:06 AM
Thank you for your help but that is only part of the calculation I am trying to do and need to incorporate into the rest of the formula but I cannot get it to work
Jan 18 2022 02:39 AM
We may be able to help you if you provide enough information.
Jan 18 2022 04:11 AM
Jan 18 2022 04:52 AM
That is precisely what the formula I posted does, but you wrote that you had trouble incorporating it. What exactly is the problem?
Jan 18 2022 05:29 AM
Jan 18 2022 05:45 AM
Jan 18 2022 07:29 AM
It should work:
Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.