# Adding a suggested number to a calculation

#### TRLUNDQVIST

##### New Member
Hi, I'm new here and to Excel, and I'm having a really hard time with the formulas.

I'm trying to create an easy way to figure out how long my long runs every week should be (30% of the week's total distance) while getting a number suggested that is added to the calculation of 30%.

When I try I get a circular error, which I can understand, but I'm not sure how to solve it.

I have five cells, four of which I add mileage during the week, I then want the fifth cell to be suggested to me, and keep the fifth cell at 30% of cell 1-5 combined.
Does this make sense?
My bad code is: E2=F2*(A2+B2+C2+D2+E2) which is circular and doesn't work, but that's the idea of it.

Any help appreciated, thank you

#### Attachments

• 2021-02-15 10_54_10-Bok2 - Excel.png
11.6 KB · Views: 2

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### joeu2004

##### Banned user
In E2:

=F2*SUM(A2:D2) / (1-F2)

The algebra is:

E2 = F2*SUM(A2:E2) = F2*SUM(A2:D2) + F2*E2
E2 - F2*E2 = F2*SUM(A2:D2)
E2*(1-F2) = F2*SUM(A2:D2)
E2 = F2*SUM(A2:D2) / (1-F2)

#### TRLUNDQVIST

##### New Member
I'm getting an error message if I put that in E2?

#### Attachments

• 2021-02-15 11_18_55-Bok2 - Excel.png
8.1 KB · Views: 1

#### joeu2004

##### Banned user
What language is your version of Excel?

Replace SUM(A2:D2) with (A2+B2+C2+D2) .

#### TRLUNDQVIST

##### New Member
That worked! I'm so happy! Thank you, so very much.

My Excel is in Swedish.

#### joeu2004

##### Banned user
Replace SUM with SUMMA.

You must be responsible for "localizing" contributions by others; especially for translating English function names.

To that end, use Excel Function Translations EN-SE - PerfectXL.

(Not surprisingly, the list is not up-to-date with the most-recent Excel versions. I did also find this in a google search: Excel Functions Translator .)

But other localization issues include different uses of period vs. comma in numbers; comma vs. semicolon as parameter and list separators; and date representations (e.g. MDY vs. DMY).

Replies
2
Views
205
Replies
1
Views
75
Replies
3
Views
144
Replies
3
Views
90
Replies
4
Views
66

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,972
Messages
5,767,397
Members
425,410
Latest member
SmittyT

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