ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula needed (https://www.excelbanter.com/excel-discussion-misc-queries/261498-formula-needed.html)

mothertucker

formula needed
 
x is 80% of y and y is a portion of the total of z. How do you calculate z?

Russell Dawson[_2_]

formula needed
 
.. . . and a portion is . . . ?
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"mothertucker" wrote:

x is 80% of y and y is a portion of the total of z. How do you calculate z?


Mike H

formula needed
 
Hi,

All you've told us is

x=y/0.8

and that isn't sufficient information to solve for z

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mothertucker" wrote:

x is 80% of y and y is a portion of the total of z. How do you calculate z?


Mike H

formula needed
 
or more accurately

x=y*0.8
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H" wrote:

Hi,

All you've told us is

x=y/0.8

and that isn't sufficient information to solve for z

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mothertucker" wrote:

x is 80% of y and y is a portion of the total of z. How do you calculate z?



All times are GMT +1. The time now is 11:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com