I don't think the formula in the OP will work FYI.
=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....
well...
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 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....
Yeah it was worded too strangely for my nerd brain.
Deebaser on
0
Deebaseron my way to work in a suit and a tieAhhhh...come on fucking guyRegistered Userregular
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....
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??
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....
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.
It's a very basic PC class. In fact I'm pissed I paid to take it and I have no choice if I want my degree. The only real benefit is my Excel skills blow but we spend a total of 4 hours on Excel. We spent roughly 4 weeks in Word and how to make folders inside of folders o_O
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.