TRLUNDQVIST
New Member
- Joined
- Feb 15, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- 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
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