Morning (depending where you are...:)

Using the following to zero figures when it's a Monday:
=IF(B18="Mon",D18,IF(D18<"",E17+D18,""))
where B18 is this:
=IF(C18="","",WEEKDAY(C18)+1) and formatted "ddd"

It doesn't work (I think) because it doesn't actually state "Mon" in the
cell. If I manually type "Mon" in, it works fine.
Is there a work around for this type of issue?

Thanks in advance
--
Traa Dy Liooar

Jock

Good Morning, Jock - you could try this:

=IF(TEXT(B18,"ddd")="Mon",D18,IF(D18<"",E17+D18," "))

if B18 contains a date. I imagine there was a typo in your post - you
can't have D18<"" (well, you can, but it doesn't mean anything).

Hope this helps.

Pete

On Aug 15, 10:20 am, Jock wrote:
Morning (depending where you are...:)

Using the following to zero figures when it's a Monday:
=IF(B18="Mon",D18,IF(D18<"",E17+D18,""))
where B18 is this:
=IF(C18="","",WEEKDAY(C18)+1) and formatted "ddd"

It doesn't work (I think) because it doesn't actually state "Mon" in the
cell. If I manually type "Mon" in, it works fine.
Is there a work around for this type of issue?

Thanks in advance
--
Traa Dy Liooar

Jock

Thanks Pete, works a treat.
Incidentally, the D18=<"" bit was correct; I'd initially set it up as but
this gave me the #value error. Funny old game....
--
Traa Dy Liooar

Jock


"Pete_UK" wrote:

Good Morning, Jock - you could try this:

=IF(TEXT(B18,"ddd")="Mon",D18,IF(D18<"",E17+D18," "))

if B18 contains a date. I imagine there was a typo in your post - you
can't have D18<"" (well, you can, but it doesn't mean anything).

Hope this helps.

Pete

On Aug 15, 10:20 am, Jock wrote:
Morning (depending where you are...:)

Using the following to zero figures when it's a Monday:
=IF(B18="Mon",D18,IF(D18<"",E17+D18,""))
where B18 is this:
=IF(C18="","",WEEKDAY(C18)+1) and formatted "ddd"

It doesn't work (I think) because it doesn't actually state "Mon" in the
cell. If I manually type "Mon" in, it works fine.
Is there a work around for this type of issue?

Thanks in advance
--
Traa Dy Liooar

Jock

"Jock" wrote in message
...
Traa Dy Liooar

Isn't there still a law in the Isle of Man whereby they shoot scotsmen or
something? <g

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

It's still legal to kill a Welshman abroad in the streets of Chester after
dusk if that's any good;)

Mike

"Sandy Mann" wrote:

"Jock" wrote in message
...
Traa Dy Liooar

Isn't there still a law in the Isle of Man whereby they shoot scotsmen or
something? <g

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Gone a bit off topic there....lol
Yes, I'm sure there's some truth in what you say Sandy as I've heard that
before. Being a Jock however, I'm permanently on the lookout for possible
vigilante nutters!!
Mike's theory seems a bit adventurous though, but, what the hey......
--
Traa Dy Liooar

Jock


"Sandy Mann" wrote:

"Jock" wrote in message
...
Traa Dy Liooar

Isn't there still a law in the Isle of Man whereby they shoot scotsmen or
something? <g

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

So, are you going to tell us what:

Traa Dy Liooar

means?

Pete

On Aug 15, 12:52 pm, Jock wrote:
Gone a bit off topic there....lol
Yes, I'm sure there's some truth in what you say Sandy as I've heard that
before. Being a Jock however, I'm permanently on the lookout for possible
vigilante nutters!!
Mike's theory seems a bit adventurous though, but, what the hey......
--
Traa Dy Liooar

Jock



"Sandy Mann" wrote:
"Jock" wrote in message
...
Traa Dy Liooar

Isn't there still a law in the Isle of Man whereby they shoot scotsmen or
something? <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk- Hide quoted text -

- Show quoted text -

=IF(TEXT(B18,"ddd")="Mon",D18,IF(D18<"",E17+D18,"" ))
would be one option, but I don't see what you're doing with B18. You are
putting into B18 a number from 2 to 8, rather than a date. You're probably
only getting away with it because Excel treats 1st Jan 1900 as a Sunday,
when it was actually a Monday.
--
David Biddulph

"Jock" wrote in message
...
Morning (depending where you are...:)

Using the following to zero figures when it's a Monday:
=IF(B18="Mon",D18,IF(D18<"",E17+D18,""))
where B18 is this:
=IF(C18="","",WEEKDAY(C18)+1) and formatted "ddd"

It doesn't work (I think) because it doesn't actually state "Mon" in the
cell. If I manually type "Mon" in, it works fine.
Is there a work around for this type of issue?

Thanks in advance
--
Traa Dy Liooar

Jock