Formula Help

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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
 
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.
 
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?
 
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.
 
=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
 
Back
Top