Percentage value Formula

moryali

New Member
Joined
Mar 15, 2018
Messages
12
Good Day

I have one amount and i need to divide it on defined percentage on 2 child for example

Total amount is 100 K and second child should take 20% from first child amount while total amount of both of them should equal 100 K , so manually first child will equal 83,333 and second child will be 16,667

so what i need to have formula to enter total value 100 K then only percentage of second child to be able to calculate values of first child and second child

Regards
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Hi,

I'm not sure I understand what you're asking, is the 20% static?


Excel 2010
ABCDE
1Amount1st Child2nd Child
210000083333.3316666.67
Sheet1
Cell Formulas
RangeFormula
D2=E2*5
E2=A2/6
 
Upvote 0

Forum statistics

Threads
1,215,599
Messages
6,125,751
Members
449,258
Latest member
hdfarid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top