Adding a suggested number to a calculation

TRLUNDQVIST

New Member
Joined
Feb 15, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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
    2021-02-15 10_54_10-Bok2 - Excel.png
    11.6 KB · Views: 2

Excel Facts

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

joeu2004

Banned user
Joined
Mar 2, 2014
Messages
3,080
Office Version
  1. 2010
Platform
  1. Windows
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
Joined
Feb 15, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I'm getting an error message if I put that in E2?
 

Attachments

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

joeu2004

Banned user
Joined
Mar 2, 2014
Messages
3,080
Office Version
  1. 2010
Platform
  1. Windows
What language is your version of Excel?

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

TRLUNDQVIST

New Member
Joined
Feb 15, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
That worked! I'm so happy! Thank you, so very much.

My Excel is in Swedish.
 

joeu2004

Banned user
Joined
Mar 2, 2014
Messages
3,080
Office Version
  1. 2010
Platform
  1. Windows
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).
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top