Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed - is this possible?
Hello,
I've heard that it maybe possible to write a formula that doesn't work after a certain date.... is this true and if so how?? Many Thanks, Kelly -- kelly m johnson London |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed - is this possible?
=IF(TODAY()39264,0/0,SUM(A1:A15))
and =IF(TODAY()39264,0/0,VLOOKUP(E33,C51:D55,2,FALSE)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Kelly 1st" wrote: Thank you! Could you give me a little example as to how were to fit it in using the already existing formulas below please? 1. =SUM(A1:A15) 2. =VLOOKUP(E33,C51:D55,2,FALSE) Many Thanks -- kelly m johnson London "Gary''s Student" wrote: =IF(TODAY()39264,0/0,0) will not work aftr the beginning of July -- Gary''s Student gsnu200712 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula needed - is this possible?
=IF(TODAY()--"1/4/07","",A1*A2)
-- David Biddulph "Kelly 1st" wrote in message ... Hello, I've heard that it maybe possible to write a formula that doesn't work after a certain date.... is this true and if so how?? Many Thanks, Kelly -- kelly m johnson London |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Appropriate formula needed! | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Worksheet Functions | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions |