PDA

View Full Version : Stop formula



deep123
2016-08-08, 04:58 AM
Hi,

Is there a way to stop running the formula in a particular cell
For eg:
Date Column B
31-08-2016 1000
30-09-2016

Value in column B changes every day.
I would like to run the formula only if today()<=31-08-2016 otherwise save previous day value.
TIA

Pecoflyer
2016-08-08, 07:53 AM
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this (http://www.excelguru.ca/content.php?184) to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

(add the link(s) without the http:// part if you are not yet authorized to post links)

Usmanbutt
2016-08-08, 10:27 AM
IN CELL B1
==IF(TODAY()<=C1,YOURFORMULA,"")

IN C1 = Your date (31/08/2016)

deep123
2016-08-09, 04:57 AM
IN CELL B1
==IF(TODAY()<=C1,YOURFORMULA,"")

IN C1 = Your date (31/08/2016)
Thank you for you reply.
I want to stop running the formula by the end of every month.
For eg: value on 31-08-2016 will remain there in column B on coming days also (formula wont work after 31-08-2016)

Usmanbutt
2016-08-09, 06:01 AM
Please upload a excel file with your expected result.

deep123
2016-08-09, 06:31 AM
Please find the attachment

Pecoflyer
2016-08-09, 07:59 AM
@deep123

Please post links to ALL your cross posts first. Your last post has been "soft deleted" but will be undeleted once the links are added. Thank you

deep123
2016-08-09, 08:00 AM
attachment

deep123
2016-08-09, 08:04 AM
not able to post links.

deep123
2016-08-09, 08:08 AM
cant copy links

Pecoflyer
2016-08-09, 08:16 AM
Read last line post #2

deep123
2016-08-09, 08:25 AM
that too not working

Pecoflyer
2016-08-09, 10:51 AM
Well, now that you have 5 posts you should be able to post a link normally.

deep123
2016-08-10, 04:39 AM
Cross posts
http://www.excelguru.ca/content.php?184
http://www.excelguru.ca/forums/forum...php?2-Formulas (http://www.excelguru.ca/forums/forumdisplay.php?2-Formulas)
http://www.excelforum.com/showthread.php?t=1150537&p=4449496#post4449496

Pecoflyer
2016-08-10, 07:24 AM
Thank you

navic
2016-08-10, 04:26 PM
Is there a way to stop running the formula in a particular cell
For eg:
Date Column B
31-08-2016 1000
30-09-2016 For me, something here is not clear.
Can you write more of the expected data (on Sheet2 and sheet1). for example, write your the expected results in the month of August, however, following the example of the September month and so on. The formula to Sheet2 is not me just to clear.
So write your many possible variants and expected situation for the next few months (on a different worksheet).

NoS
2016-08-10, 05:45 PM
navic, here's the file the OP posted at EF

5564

My take on this is that the OP is asking for a formula with a Circular Reference.
...If the end of month date has not been exceeded... run the formula
...If the end of month date has been exceeded... keep the value already in the cell

Would I be on the right track thinking you will use Sumif ?

deep123
2016-08-11, 05:59 AM
Please find the attached updated file

navic
2016-08-13, 07:49 AM
thanks @NoS
If the OP asked a question on another forum, then let him put a link here.


@deep123
If I understood you well, you can try

On Sheet2 add "helper" column for Number of Month
On Sheet1 there is two formulas (1st and 2nd copy down)
See attached file

deep123
2016-08-16, 11:27 AM
Thank you for the reply.
But in this file also the value changes after end of august. I want to stop running the formula at the end of every month

navic
2016-08-16, 08:38 PM
But in this file also the value changes after end of august.Then search for VBA (http://www.excelguru.ca/forums/forumdisplay.php?9-VBA-Programming)