Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If And Formula
O35 = Sunday
T25 = 06:00:00 R 35 = End time of fault ie 05:21:00 What i want to do is check cell O35, if it is sunday and the end time is after 06:00:00 i want the end value to be 06:00:00 or if the end time is before 06:00:00 i want the end time to equal r 35 i am trying this formula iF(AND(O35 ="Sunday",R35T25),T25,R35) but getting nowhere can anyone help please thanks kevin |