|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 10th, 2010, 06:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
May 10th, 2010, 06:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
May 10th, 2010, 07:49 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#4
May 10th, 2010, 07:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#5
May 10th, 2010, 10:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
