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

If And Formula
 

Kevin
Formula is correct, I simulated it and that works fine. Looks like
that there is something wrong with the Time Format you are entering.
Ensure that you are entering time as a value not as a text.

AQIB RIZVI

If And Formula
 

hi,
i plugged your formula in a blank worksheet and it works. needs an equal
sign in front but other than than it works.
what are you having problems with?
check your formating.
regards
FSt1


"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
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

If And Formula
 

Hi,

Looks like O35 is actually a date formatted as dddd and not text so try this:

=iF(AND(WEEKDAY(O35) =1,R35T25),T25,R35)


HTH
Jean-Guy


"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
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

If And Formula
 

The OP should move to O35 and tell us what he sees in the Formula Bar
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"pinmaster" wrote in message
...
Hi,

Looks like O35 is actually a date formatted as dddd and not text so try
this:

=iF(AND(WEEKDAY(O35) =1,R35T25),T25,R35)


HTH
Jean-Guy


"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
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

If And Formula
 

=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
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

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 -

If And Formula
 

Hi,

What is in O35? is it text? or a date formatted as "dddd" which would give
days of the week? If it is text then the formula is sound, if it is a date
then try the formula I gave you in my first post!

=IF(AND(WEEKDAY(O35)=1,R35T25),T25,R35)

Regards!
Jean-Guy

"kevcar40" wrote:

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 -