A formula referencing another
 

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

A formula referencing another
 

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

A formula referencing another
 

=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

A formula referencing another
 

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

A formula referencing another
 

"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

A formula referencing another
 

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

A formula referencing another
 

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

A formula referencing another
 

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 -

A formula referencing another
 

Pete,

I asked yesterday, It's Manx Gaelic for 'Time Galore' or 'Time Enough'.

Mike

"Pete_UK" wrote:

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 -

A formula referencing another
 

Ahh ... Hence Sandy's reference to the Isle of Man !!

Thanks,

Pete

On Aug 15, 2:36 pm, Mike H wrote:
Pete,

I asked yesterday, It's Manx Gaelic for 'Time Galore' or 'Time Enough'.

Mike



"Pete_UK" wrote:
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 -- Hide quoted text -

- Show quoted text -