# 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

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### 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
223
Replies
10
Views
107
Replies
3
Views
102
Replies
1
Views
44
Replies
1
Views
151

1,129,548
Messages
5,636,927
Members
416,952
Latest member
Dougiefletcher

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