If And Formula
On 11 Nov, 16:53, Teethless mama
wrote:
=IF(O35="Sunday",MIN(R35,T25),R35)
"kevcar40" wrote:
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
Thanks All
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- Hide quoted text -
- Show quoted text -
|