Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.fr.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc,microsoft.public.fr.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
in A1, put in 175
in A2 put in =A1+25 then drag fill down the column. -- Regards, Tom Ogilvy "Dianna" wrote in message om... 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? |
#3
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
may be another soluce ???? in A1, put in 175 in A2 put in =A1+25*(COUNTA($A$1:A1)) then drag fill down the column. results: 175 200 250 325 425 Regards Tom Ogilvy wrote: in A1, put in 175 in A2 put in =A1+25 then drag fill down the column. "Dianna" wrote in message om... 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? |
#4
![]()
Posted to microsoft.public.excel.misc,microsoft.public.fr.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 =A1+(row()-1)*25 if starting in B9 for example put 175 in B9, in B10 put in =B9+row(A1)*25 and drag fill down -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... in A1, put in 175 in A2 put in =A1+25 then drag fill down the column. -- Regards, Tom Ogilvy "Dianna" wrote in message om... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |