Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

formula help (running summ)

Experts, I am not sure if this can be done without a module.  Can the formula below be amended to add 250 each time the data changes?  

eg:  if 250 is the result already in teh cell then add another 250 when it is true and if there was nothing in the cell then it woudl start with 250.  IN a sense it is a running summ.  

thanks...

=IF(AND($D142>$I$18,$D142<$J$18),250,0)
0
pdvsa
Asked:
pdvsa
3 Solutions
 
SiddharthRoutCommented:
Like this

=if(A1="",250,A1+250)

Sid
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

If you want to add 250 every time a value in the cell changes, then you will need a macro. It is not good practice, though to manipulate cell values with macros without leaving an audit trail about these changes.

How would you ever be able to tell how many times the value has changed and another 250 has been added?

Maybe it's better to step back and review your data layout and calculation logic to see if there is a different approach. What are you trying to achieve?

cheers, teylyn
0
 
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
Are you talking about incrementing the value in the same cell as the formula?
0
 
pdvsaProject financeAuthor Commented:
sid:  I dont think this incorporates the criteria of the original?

Tbone:
<Are you talking about incrementing the value in the same cell as the formula
yes.

teylyn: it is a little difficult to put into words.  

Let me know if this changes your ideas...otherwise I might have to leave as is.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now