Formula Help
 

I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z3 = 8:00

Formula Help
 

I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z2=06:01
Z3 = 8:00

Formula Help
 

By your example, not sure what you are wanting -
Your question says, if the information is within a certain time span

Knowing nothing else, I would have guess that you are looking for

=if(and(m5=u2,m5<=u3),R5,0)

Which, in english, means if 18:03 is greater than (or equal to) 18:00 and
less than (or equal to) 20:00, insert the information from cell R5, otherwise
make the cell value zero.

Does this help?
--
Wag more, bark less


"Peter" wrote:

I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z2=06:01
Z3 = 8:00

Formula Help
 

Possibly you are looking at m5 is in one of two ranges and you could use the
following:

=if(or(and(m5=Z2,m5<=Z3),and(m5=u2,m5<=u3)),R5,0 )

If this is true and you want nothing to be displayed use the following formula

=if(or(and(m5=Z2,m5<=Z3),and(m5=u2,m5<=u3)),R5," ")

The "" = means put nothing into the cell.

--
Wag more, bark less


"Brad" wrote:

By your example, not sure what you are wanting -
Your question says, if the information is within a certain time span

Knowing nothing else, I would have guess that you are looking for

=if(and(m5=u2,m5<=u3),R5,0)

Which, in english, means if 18:03 is greater than (or equal to) 18:00 and
less than (or equal to) 20:00, insert the information from cell R5, otherwise
make the cell value zero.

Does this help?
--
Wag more, bark less


"Peter" wrote:

I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z2=06:01
Z3 = 8:00

Formula Help
 

=IF(OR(AND(K6=U3,K6<=U4),AND(K6=Y3,K6<=Y4)),R6,0 )
What I am looking for is basically what you stated, if K5 is between 18:01
and 20:00 the I want the value of R6 inserted,and if it is not then I want
the 0. However it is inserting the value of R6 even if it is not.
K6 valuse is 22:15
U3= 18:01
U4= 20:00
Y3= 6:00
Y4= 8:00
So it is not between these two but it is still putting the value of R5, but
it is in the right step I was way off...:)
I have four different two hour in both military time and standard. 6-8,
8-10, 10-12 then 12-6

"Brad" wrote:

Possibly you are looking at m5 is in one of two ranges and you could use the
following:

=if(or(and(m5=Z2,m5<=Z3),and(m5=u2,m5<=u3)),R5,0 )

If this is true and you want nothing to be displayed use the following formula

=if(or(and(m5=Z2,m5<=Z3),and(m5=u2,m5<=u3)),R5," ")

The "" = means put nothing into the cell.

--
Wag more, bark less


"Brad" wrote:

By your example, not sure what you are wanting -
Your question says, if the information is within a certain time span

Knowing nothing else, I would have guess that you are looking for

=if(and(m5=u2,m5<=u3),R5,0)

Which, in english, means if 18:03 is greater than (or equal to) 18:00 and
less than (or equal to) 20:00, insert the information from cell R5, otherwise
make the cell value zero.

Does this help?
--
Wag more, bark less


"Peter" wrote:

I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5, if(and(M5=<U3,R5, if(M5=Z2,R5,if(and(M5=<Z3,R5))))))
M5 = 18:03
U2 = 18:00
R5 is what I want there is M5 is withing the paramenters
U3 = 20:00
Z2=06:01
Z3 = 8:00