Forum Discussion
stjohn
Jan 29, 2025Copper Contributor
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...
- Jan 30, 2025
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
NnyiimockBitanyanmi
Jan 30, 2025Brass Contributor
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
stjohn
Jan 31, 2025Copper Contributor
Thank you! That worked. 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.
- NnyiimockBitanyanmiFeb 01, 2025Brass Contributor
Glad to hear it did