# Nested formula

#### bullit_nl

##### Active Member
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

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Joe4

Is this what you are looking for?
Excel Formula:
``=((C1/A1)*A2)/B3``

#### bullit_nl

##### Active Member
Is this what you are looking for?
Excel Formula:
``=((C1/A1)*A2)/B3``

Hello Joe,

Yes that is exactly what I'm looking for.
Can you add a value error in front of it too?

#### bullit_nl

##### Active Member

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

#### Joe4

=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:
Excel Formula:
``=IF(B3=0;0;((C1/A1)*A2)/B3)``

#### bullit_nl

##### Active Member
Ok perfect.
Again thank you very much.

#### Joe4

You are welcome.
Glad I was able to help!

Replies
15
Views
202
Replies
10
Views
95
Replies
3
Views
96
Replies
1
Views
43
Replies
1
Views
145

1,128,099
Messages
5,628,678
Members
416,332
Latest member
blkbeltmjk

### 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.

### Which adblocker are you using?

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

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