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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|