How to delay the execution of formula

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

Hi,

the simplest way (if you're talking weeks) would be
to place an apostrophe in front of your formulas:

= A1 * B1 becomes '= A1 * B1

This just turns the cell to text. Remove the apostrophe
when you're ready for cells to be formulas again.

jeff
-----Original Message-----
I have a worksheet with data/formulae etc etc. I would
Click to expand...
like to delay the execution of formula for certain column
by few weeks and after the completion of the delayed
period I would like the formula to be executed
automaticllay.
Is it possible to do without using VB. If i have to use
Click to expand...
VB please be kind enough to give one simple example.
 
LOL!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delay in formula 1
Calculating weeks 1
EXCEL FORMULA 2
Question on the formula 1
Formula IF 1
help with formula 1
Formula Content linked to other cells formula Content 5
The real Horizontal Formula question 4

Back
Top