I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

Yes you can use them in the same formula but those are not times they are
text strings so you need to break them up in time values if you need any
sort of calculation done. Maybe you can explain in detail what you want to
do, how you expect a result to look etc?

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished
with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

Peo, I download a series of prices based on a certain number of price ticks.
As each series of ticks is completed it also includes the time of completion
in 24hour format. So I have columns with Time, Open, High, Low, Close,
followed by a series of columns of technical indicators for daily periods of
24 hours. I only want to perform additional work the data from the periods
mentioned above so I was using AND and realized using if(and(a1959, a1<1131,
a11259, a1<1501),if(the rest of my calculations in this section,"")"").
This version caused the additional calculations to be performed on all rows
of data rather than only the two periods during the day I was looking for. I
was hoping to be able to insert the OR statement after the logical test
a1<1131 but could not master it. My lack of experience is probably showing
but I would appreciate any help you could provide. Thanks! Dave

"Peo Sjoblom" wrote:

Yes you can use them in the same formula but those are not times they are
text strings so you need to break them up in time values if you need any
sort of calculation done. Maybe you can explain in detail what you want to
do, how you expect a result to look etc?

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished
with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

It would look like this incorporating OR


=IF(OR(AND(A1959,A1<1131),AND(A11259,A1<1501))," Do This","Do That")

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
Peo, I download a series of prices based on a certain number of price
ticks.
As each series of ticks is completed it also includes the time of
completion
in 24hour format. So I have columns with Time, Open, High, Low, Close,
followed by a series of columns of technical indicators for daily periods
of
24 hours. I only want to perform additional work the data from the
periods
mentioned above so I was using AND and realized using if(and(a1959,
a1<1131,
a11259, a1<1501),if(the rest of my calculations in this section,"")"").
This version caused the additional calculations to be performed on all
rows
of data rather than only the two periods during the day I was looking for.
I
was hoping to be able to insert the OR statement after the logical test
a1<1131 but could not master it. My lack of experience is probably
showing
but I would appreciate any help you could provide. Thanks! Dave

"Peo Sjoblom" wrote:

Yes you can use them in the same formula but those are not times they are
text strings so you need to break them up in time values if you need any
sort of calculation done. Maybe you can explain in detail what you want
to
do, how you expect a result to look etc?

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished
with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

On Sep 24, 1:46 pm, Dave wrote:
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

Yes, you can.

OR(AND(A11000,A1<1130),AND(A11330,A1<1500))

Note that I'm just giving you the syntax. I'm assuming you have those
times in other cells, you should use references to them. Otherwise,
the actual numbers for these times are decimals, like 1:30pm is .5625
to Excel.

"Peo Sjoblom" wrote:

It would look like this incorporating OR


=IF(OR(AND(A1959,A1<1131),AND(A11259,A1<1501))," Do This","Do That")

-- Peo
Thank you.....it works as I need it, (in spite of my poor description to you)!
I hope someday I will be expreienced enough to pay forward the help you gave
me today. Thanks Again! Dave Columbus, Ohio


Regards,


Peo Sjoblom

"Dave" wrote in message
...
Peo, I download a series of prices based on a certain number of price
ticks.
As each series of ticks is completed it also includes the time of
completion
in 24hour format. So I have columns with Time, Open, High, Low, Close,
followed by a series of columns of technical indicators for daily periods
of
24 hours. I only want to perform additional work the data from the
periods
mentioned above so I was using AND and realized using if(and(a1959,
a1<1131,
a11259, a1<1501),if(the rest of my calculations in this section,"")"").
This version caused the additional calculations to be performed on all
rows
of data rather than only the two periods during the day I was looking for.
I
was hoping to be able to insert the OR statement after the logical test
a1<1131 but could not master it. My lack of experience is probably
showing
but I would appreciate any help you could provide. Thanks! Dave

"Peo Sjoblom" wrote:

Yes you can use them in the same formula but those are not times they are
text strings so you need to break them up in time values if you need any
sort of calculation done. Maybe you can explain in detail what you want
to
do, how you expect a result to look etc?

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished
with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

Spiky
When you experienced folks write the syntax and I then see it...it seems so
simple and logical.....but without your initial hand up by showing the
actual syntax to get me started it seems like confetti.
Thanks you!
Dave

"Spiky" wrote:

On Sep 24, 1:46 pm, Dave wrote:
I'm performing calculations on market data during specific times.
(1000AM to 1130AM and 1330PM to 1500PM)
Can I include both AND and OR in my function, or can it be accomplished with
only one of these items?
If so, could you provide the syntax?
Thanks in advance.

Yes, you can.

OR(AND(A11000,A1<1130),AND(A11330,A1<1500))

Note that I'm just giving you the syntax. I'm assuming you have those
times in other cells, you should use references to them. Otherwise,
the actual numbers for these times are decimals, like 1:30pm is .5625
to Excel.

My pleasure Dave, thanks for the feedback. It feels good helping nice polite
people like yourself.

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...


"Peo Sjoblom" wrote:

It would look like this incorporating OR


=IF(OR(AND(A1959,A1<1131),AND(A11259,A1<1501))," Do This","Do That")

-- Peo
Thank you.....it works as I need it, (in spite of my poor description to
you)!
I hope someday I will be expreienced enough to pay forward the help you
gave
me today. Thanks Again! Dave Columbus, Ohio


Regards,


Peo Sjoblom