How to find total Amount with excel formula as on the sample sheet attached with this
How to find total Amount with excel formula as on the sample sheet attached with this
Last edited by john555; 06-07-2023 at 07:24 AM.
Perhaps you could give a bit more information. You have three worksheets in your workbook, there is no "total" column or row, I do not see data that can be added to get a total, what is supposed to be "totaled" and where?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Attached file was not correct , now I corrected.
And how did you arrive at that final rate? What's the calculation?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It is from a invoice copy and I don't know the calculation. But amount is coming like that. How to find the calculation
I suggest that you ask whoever sent you the invoice how they arrived at the Total Amount.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
From the looks of it, this is your calculation...
=B9*(C9-E9)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Jete thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks