Hello friends,
Gross 2000000
18% 360000 (18% never changes)
2% 40000 (this is a dynamic value and keeps changing to 8%, 10% etc.)
Net 2320000
This is what I have in range A1:B4
Formula in B2 : =B1*A2
Formula in B3 : =B1*A3
Formula in B4 : =SUM(B1:B2)-B3
I am unable to calculate it reverse. Lets say I have only two values available, Net ( 2320000) and 2% then how can I calculate the Gross (2000000)?
Please help.
IF you have
A1=2%
A2=232000
Try in A3=
=A2/(1+18%-A1)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or, following your original cells location:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
Thanks !Originally Posted by nflsales
Exactly what I needed
Thank youOr, following your original cells location:
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
oops! forgot to do that.
Thanks for reminding
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks