Percentages: how to derive a $ figure from them

[wylie27]

Hello all,

I have an issue which i am sure is an order of operation issue.

Column A: is a percentage of total Revenue for an department. it is derived by departments revenue / overall revenue
Column B: is the cost of infrastructure.
Column C: I want to see the percentage of the overall revenue that is spent on infrastructure.


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]9.88%[/TD]
[TD]15150[/TD]
[TD]revenue % cost of infra[/TD]
[/TR]
</tbody>[/TABLE]



THe formula i have been trying is

=(B1/(100*A1)) which results in an answer of 1533.400 which is incorrect.

I am sure i am just doing something wrong in the order of operations.

An y help would be great.

 

[offthelip]

You have got insufficient data to work it out. You either need to know what the actual total revenue is or what percentage of the total revenue infrastructure is. This has got nothing to do with EXCEL just arithmetic

 

[wylie27]

Offthelip,

The 9.88% is the percentage of revenue.. I am wanting to workout what percentage of infra costs are

The number should be 1496.

Or am i missing something.

 

[offthelip]

Yes you are, column a = DR/TR
column B = CI
You want to calculate CI/TR, you cant do it unless you also know either DR , Tr or CI/TR

 

[dlrollings83]

If you are looking to return a value of 1496, this is =rounddown(B1/100)*A1. It will return the result you are after but not 100% that is what you are after.

 

[jtakw]

Hi,

From above post, =rounddown(B1/100)*A1 is not a valid formula.

But if OP just wants 1496 as result, it's simply =A1*B1

Whether you want it rounded or not, that's up to you to wrap it with a ROUND function.

 

[wylie27]

thanks for the feedback everyone. You are all right. I need to rethink how i am approaching this. but first a coffee...

offthelip. i see what you are saying and will give that a go.

Regards