Adding a suggested number to a calculation

[TRLUNDQVIST]

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

 

[joeu2004]

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]

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

 

[joeu2004]

What language is your version of Excel?

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

 

[TRLUNDQVIST]

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

My Excel is in Swedish.

 

[joeu2004]

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