Nested formula

[bullit_nl]

Hello,

I'm trying to calculate a rate with a formula into one cell. I don't know if this is possible because I need some of the results of the calculations in the result of that formula.

First I need the percentage of C3 of total number in A1 > then I want to multiply that percentage with a number value in cell A2> then I want to divide that result to a number value in B3.

Thank you

 

[Joe4]

Is this what you are looking for?

=((C1/A1)*A2)/B3

 

[bullit_nl]

Is this what you are looking for?

=((C1/A1)*A2)/B3

Hello Joe,

Thank you very much for your quick reply!
Yes that is exactly what I'm looking for.
Can you add a value error in front of it too?

 

[bullit_nl]

Think I already figured it out how to add that:

=IFERROR(((C1/A1)*A2)/B3;0)

 

[Joe4]

Think I already figured it out how to add that:

=IFERROR(((C1/A1)*A2)/B3;0)

Yes, if there is a possibility of error, you can wrap it in an IFERROR.

The most common cause of error in a situation like this is trying to divide by zero. Another way of handling that could be:

=IF(B3=0;0;((C1/A1)*A2)/B3)

 

[bullit_nl]

Ok perfect.
Again thank you very much.

 

[Joe4]

You are welcome.
Glad I was able to help!