Forum Discussion
Solved
Excel Formula
What is the correct formula in Excel to calculate net pay? I have tried several, but the amount is a penny off. I'd like to subtract social security and medicare payments from the gross salary. Wh...
It will be easy for us to help if you have a workbook or dummy data with screenshot. But could this help;
=SUM(A2)-(B2+C2). This formula assumes that you have your gross salary in A2
Please provide detailed and specific information.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Later, I did attach what I've been trying, but I don't see it. This is my first time posting, so I may have done something wrong. The formula the other guy posted worked!