P
Phil B.
Unfortunately, this function comes back with a 7.5 or FALSE for both Sat and
Sun.
Sun.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Baffled
Hi there
I would use this formula
=IF(B1="sat",0,IF(B1="sun",0,7.5))
See if that works
D
I would use this formula
=IF(B1="sat",0,IF(B1="sun",0,7.5))
See if that works
D
D
David Biddulph
Does B1 actually contain the text "Sat", or is it a date formatted as ddd?
If the latter, change Shane's formula from
=IF(OR(B1="Sat",B1="Sun"),0,7.5)
to
=IF(OR(TEXT(B1,"ddd")="Sat",TEXT(B1,"ddd")="Sun"),0,7.5)
If the latter, change Shane's formula from
=IF(OR(B1="Sat",B1="Sun"),0,7.5)
to
=IF(OR(TEXT(B1,"ddd")="Sat",TEXT(B1,"ddd")="Sun"),0,7.5)
T
Tom Hutchins
Shane's formula works if your DAYs are text values or date values formatted
using the TEXT function. If, instead, your DAYs are actual date values
displayed using custom formats, then a formula like this should work:
=IF(OR(WEEKDAY(B1)=1,WEEKDAY(B1)=7),0,7.5)
This assumes that the first day is in cell B1.
Hope this helps,
Hutch
using the TEXT function. If, instead, your DAYs are actual date values
displayed using custom formats, then a formula like this should work:
=IF(OR(WEEKDAY(B1)=1,WEEKDAY(B1)=7),0,7.5)
This assumes that the first day is in cell B1.
Hope this helps,
Hutch
S
ShaneDevenshire
Hi,
As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.
If the entries are actual dates then here is a really short formula:
=IF(MOD(A1,7)>1,7.5,0)
As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.
If the entries are actual dates then here is a really short formula:
=IF(MOD(A1,7)>1,7.5,0)
T
Teethless mama
This one even shorter.
=(MOD(A1,7)>1)*7.5
=(MOD(A1,7)>1)*7.5
ShaneDevenshire said:Hi,
As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.
If the entries are actual dates then here is a really short formula:
=IF(MOD(A1,7)>1,7.5,0)
P
Phil B.
And the winner goes to Teethless mama!
It worked . . . THANKS to all!
It worked . . . THANKS to all!