A formula referencing another

[Jock]

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

 

[Pete_UK]

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

 

[David Biddulph]

=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.

 

[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

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

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

Mike

 

[Jock]

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......

 

[Pete_UK]

So, are you going to tell us what:

Traa Dy Liooar

means?

Pete

 

[Mike H]

Pete,

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

Mike

 

[Pete_UK]

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

Thanks,

Pete