As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
Little Excel Help
King Kong
Registered User regular
Registered User regular
I have 2 number totals I am increasing by 20% I have to come up with 3 different formulas to do it.
For one example I typed 120% in a cell and multplied that cell by my number total (I.E. =SUM(B10*J1))
What are some other methods I could use to come up with the same value?
For one example I typed 120% in a cell and multplied that cell by my number total (I.E. =SUM(B10*J1))
What are some other methods I could use to come up with the same value?
King Kong on
0
Posts
=SUMPRODUCT(B10,J1)
I'm not really sure what the point of this is, or if this is what you mean.
Also, =SUM(B10*J1) isn't really a formula....the SUM function with one argument doesn't do anything....you might as well just do =B10*J1
=SUM(Cell1:Cell2) *1.20 is what i think you were going for.
edit:
or =SUM(Cell1:Cell2) *J1
Yeah, it depends what his reference cells contain. If B10 is already a SUM, and J1 is 1.2, then what he has will work...but it would just be a weird way of doing it....
I have a number.. X that needs to be increased by 20% in teh next cell below.
What could I put in a cell below X that would calculate this for me.
A1 is say 23,000
What could I use in A2 to add 20% to that number
For his example he had us put 120% in J1 and had us do X*J1
Sorry my Excel skills are so shitty and my math is even worse.
=SUMPRODUCT(A1,J1)
These should both do it.
A1*1.2
A1 + (A1*.2)
A1 * 2 - (A1*.8)... how ridiculous do we need to get?
To add 20%, you just need to find 120% of the number, which is the same as multiplying by 1.2. There's no reason to get more complicated than that really.
Yeah it was worded too strangely for my nerd brain.
Yeah it was worded too strangely for my nerd brain.
Oh yeah, and this is a retarded excel assignment. Find three different ways to do one simple thing??
You should punch your teacher in the nose, imo.
I think it would be a good exercise if it were something like:
1 3
6 8
5 2
And he wanted you to multiply 1*3, 6*8, 5*2, then add them up, because then it would teach you how to do product, sum, and also sumproduct. But I agree, as it is, it seems really silly and worthless.