Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
If the entered date is either Saturday or sunday, then calculatio
should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
Hi
try =IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) Frank If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
The formula should be
=IF(AND(J6<0,OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7)),TRU E,FALSE ----- Supriya wrote: ---- If the entered date is either Saturday or sunday, then calculatio should take place =IF(OR(WEEKDAY(J6)=1,7),"True","False" Is the above formula is correct -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
No. Try this:
=IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) HTH, Nikos "Supriya " wrote in message ... If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
Supriya,
If you just want True or False, you can siumply use =OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =IF(OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7),"True","False" ) Frank If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
One way:
=WEEKDAY(J6,3)4 or =IF(WEEKDAY(J6,3)4,<do if true,<do if false) In article , Supriya wrote: If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
Try
=IF(WEEKDAY(J6,3)4,"True","False") -- Supriya wrote in message ... If the entered date is either Saturday or sunday, then calculation should take place. =IF(OR(WEEKDAY(J6)=1,7),"True","False") Is the above formula is correct? --- Message posted from http://www.ExcelForum.com/ |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical or
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there an AND logical ? | Excel Worksheet Functions | |||
is there an AND logical ? | Excel Worksheet Functions | |||
Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
Logical AND with SUM | Excel Worksheet Functions | |||
Logical Value | Excel Worksheet Functions |