OVH Cloud OVH Cloud

Formula

9 réponses
Avatar
princess_di_69145
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25=200
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?

9 réponses

Avatar
Tom Ogilvy
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?


Avatar
Denis
In France, we say hello first
Then
in A1, 175
in A2 ¡+(LIGNE()-1)*25
With your excel replace LIGNE by ROW???
then drag fill down the column.

Then Thanks

Denis
-----Message d'origine-----
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?
.



Avatar
Modeste
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.




Avatar
jps
fortunately, there are still on this earth poor frenchmen for saving a
compromised situation....
unfortunately, modeste's answer has not been postcrossed and I bet that
Dianna wont never get the good solution...and once again, we have to note
that Dianas have no chance when they have something to do with France...
jps

"Modeste" a écrit dans le message de
news:5ad501c4cb2c$69e40fd0$
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.






Avatar
Pounet95
Comment pas de chance?
Et le fait qu'il y ait encore de "poor frenchmen for saving ...." n'en est
pas une ?

--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
"jps" a écrit dans le message de
news: %
fortunately, there are still on this earth poor frenchmen for saving a
compromised situation....
unfortunately, modeste's answer has not been postcrossed and I bet that
Dianna wont never get the good solution...and once again, we have to note
that Dianas have no chance when they have something to do with France...
jps

"Modeste" a écrit dans le message de
news:5ad501c4cb2c$69e40fd0$
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.









Avatar
Pierre CFI [mvp]
salut jp
là tu perds ton temps (sauf si le but est d'épater les lecteurs par ta maitrise de l'anglais, de l'allemand, du begayement et le
zézaillement) car les réponses sont sur fr.excel et la question sur excel tout court donc US
mais c'est pas inintérressant ta façon de te placer

--
Pierre CFI
MVP Microsoft Access
Mail : http://cerbermail.com/?z0SN8cN53B

Site pour bien commencer
Access http://users.skynet.be/mpfa/
Excel http://www.excelabo.net
Site perso
http://access.cfi.free.fr
"jps" a écrit dans le message de news:%
fortunately, there are still on this earth poor frenchmen for saving a
compromised situation....
unfortunately, modeste's answer has not been postcrossed and I bet that
Dianna wont never get the good solution...and once again, we have to note
that Dianas have no chance when they have something to do with France...
jps

"Modeste" a écrit dans le message de
news:5ad501c4cb2c$69e40fd0$
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.









Avatar
twinley
se placer ? droit dans le mur oui, pardon le pilier...

--
à+twinley
"Pierre CFI [mvp]" a écrit dans le message de
news:edq%
salut jp
là tu perds ton temps (sauf si le but est d'épater les lecteurs par ta
maitrise de l'anglais, de l'allemand, du begayement et le

zézaillement) car les réponses sont sur fr.excel et la question sur excel
tout court donc US

mais c'est pas inintérressant ta façon de te placer

--
Pierre CFI
MVP Microsoft Access
Mail : http://cerbermail.com/?z0SN8cN53B

Site pour bien commencer
Access http://users.skynet.be/mpfa/
Excel http://www.excelabo.net
Site perso
http://access.cfi.free.fr
"jps" a écrit dans le message de
news:%

fortunately, there are still on this earth poor frenchmen for saving a
compromised situation....
unfortunately, modeste's answer has not been postcrossed and I bet that
Dianna wont never get the good solution...and once again, we have to
note


that Dianas have no chance when they have something to do with France...
jps

"Modeste" a écrit dans le message
de


news:5ad501c4cb2c$69e40fd0$
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.













Avatar
GD
Bonsour ®,
d'une certaine façon ceci me rassure car les 2 ou 3 fois ou j'ai participé à
des fils incluant Tom,
celui ci n'a pas daigné émettre de commentaire ...
:-(
compromis... chose due !!!
;o)))
une fijps wrote:
fortunately, there are still on this earth poor frenchmen for saving a
compromised situation....
unfortunately, modeste's answer has not been postcrossed and I bet
that Dianna wont never get the good solution...and once again, we
have to note that Dianas have no chance when they have something to
do with France... jps

"Modeste" a écrit dans le
message de news:5ad501c4cb2c$69e40fd0$
I beg your pardon TOM !!
(I am afraid of committing a crime of high treason)
your soluce :
175
200
225
250
275

in A1, put in 175
in A2 put in
¡+25*(COUNTA($A$1:A1))
then drag fill down the column.
175
200
250
325
425

Regards

-----Message d'origine-----
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?



.







Avatar
Tom Ogilvy
Ignore my answer, I just read yout first line description:

On excel how do I add 25 to my previous product


which doesn't appear to be what you want. Fpr that:

If starting in A1
put in 175
then

¡+(row()-1)*25

if starting in B9 for example
put 175 in B9, in B10 put in

¹+row(A1)*25

and drag fill down

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
news:
in A1, put in 175
in A2 put in
¡+25

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Dianna" wrote in message
news:
On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25 0
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?