Slogging through an excel spreadsheet...
- Thread starter NAOMIN
- Start date
firemath
Full Member
- Joined
- Oct 29, 2019
- Messages
- 602
Romsek beat me to it, but they factored it.
[MATH](A1*B1)-(A1*B1*0.93)+(A1*C1)[/MATH]
Take A1 out of all expressions:
[MATH]A1(B1)-A1(B1*0.93)+A1(C1)[/MATH]
[MATH]2A1-A1=A1[/MATH], and [MATH]B1-B1(0.93)=0.07*B1[/MATH], so
[MATH]A1(0.07*B1+C1)[/MATH]
[MATH](A1*B1)-(A1*B1*0.93)+(A1*C1)[/MATH]
Take A1 out of all expressions:
[MATH]A1(B1)-A1(B1*0.93)+A1(C1)[/MATH]
[MATH]2A1-A1=A1[/MATH], and [MATH]B1-B1(0.93)=0.07*B1[/MATH], so
[MATH]A1(0.07*B1+C1)[/MATH]
Thank you both, and Firemath's walkthrough brought me back to my 9th grade lessons. Thanks!
D
Deleted member 4993
Guest
[MATH]2A1-A1=A1[/MATH], and [MATH]B1-B1(0.93)=0.07*B1[/MATH], so
This is correct but why is it needed for this problem?
Subhotosh, if your question is for me, it’s that I had a series of odd calculations to do on a purchasing s.s. that involved percentages for one number in a series, not for another, returning the resulting formula, and although it showed the logical path through the calculations, clearly could be simplified. It was just out of curiosity.
D
Deleted member 4993
Guest
The question was related to firemath's response
firemath
Full Member
- Joined
- Oct 29, 2019
- Messages
- 602
I did it so [MATH]-A1[/MATH] would not be a coefficient.
D
Deleted member 4993
Guest
Please show me - where you had used
2A1−A1=A1
In your calculation? Your response (#3)/calculations:
Romsek beat me to it, but they factored it.
(A1∗B1) − (A1∗B1∗0.93) +(A1∗C1)
Take A1 out of all expressions:
A1(B1)−A1(B1∗0.93)+A1(C1)
2A1−A1=A1, and
B1−B1(0.93)=0.07∗B1, so
A1(0.07∗B1+C1)