If Statement Help

M

MJSlattery

Dear JulieD:

I am very grateful for your help, If I understand your sugestion,
would need to write a VBA macro to cut and paste-special the capture
data into a new column?

You would think that excel would provide a more elegant manor t
capture volitale data when it meets a condition that is defined by
formula. Capture being the operative word here.

Is there another function other than "IF" that would be mor
appropiate?

Is there an email address and I will send you a copy o
STOCKEVULATE.exl

Thanks again,

Michae
 
J

JulieD

Hi Michael

comments in-line below:
I am very grateful for your help, If I understand your sugestion, I
would need to write a VBA macro to cut and paste-special the captured
data into a new column?
Click to expand...
- yes, or over the same column
You would think that excel would provide a more elegant manor to
capture volitale data when it meets a condition that is defined by a
formula. Capture being the operative word here.
Click to expand...
- formulas are volitial ... by definition
Is there another function other than "IF" that would be more
appropiate?
Click to expand...
- no, what you want is not possible with any formula
Is there an email address and I will send you a copy of
STOCKEVULATE.exl
Click to expand...
julied_ng at hcts dot net dot au

looking forward to hearing from you
Cheers
JulieD
 
Top