# Circular formulas

#### Strebal

##### New Member
How do I use a circular formula. Example

cell A1 = .01* A5

a1 = (.01*a5)
a2 = 20
a3= 30
a4 = 100

a5 = (the total of a1:a4)

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
What answer do you expect from this?

Not sure where this is going, but you can try this

=(0.01/0.99)*SUM(A2:A4)

in A1 and

=SUM(A1:A4)

in A5 and see if it is what you need.

Seti:

Where do you get (0.01/0.99) from?

I was thinking:

In A1:
=0.01*SUM(A2:A4)

In A5:
=SUM(A1:A4)

thanks

Hotpepper, I think that will work. Dont know why I didnt of it. Thank to all for the help.

HotPepper,

I solved the algebra

A5=A1+A2+A3+A4

A1=.01*A5

A5=(.01*A5)+A2+A3+A4

.99*A5=SUM(A2:A4)

A5=SUM(A2:A4)/.99

A1=.01*A5

A1=(.01/.99)*SUM(A2:A4)

But this was guess based on the original post and I could be very wrong.

Replies
11
Views
536
Replies
2
Views
218
Replies
1
Views
148
Replies
2
Views
213
Replies
6
Views
443

1,219,997
Messages
6,151,361
Members
451,022
Latest member
Baijano23

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