Tag Archive | validation

Conditional Comments – Spawn or Saviour?

Having found out IE10 will No Longer Support Conditional Comments, I wondered if version 1.3 of the W3’s Markup Validator supported them yet. Turns out it’s a no (surprise surprise)…

However: looking more closely at MSDN’s article on downlevel hidden / revealed comments (yes: buzzwords alert!) I notice that the Validator only complains about proper downlevel comments… Read More…

Excel shenanigans

I have been involved with a great stack of data over the last few months; building a massive formula that so far covers all the possible falsey input I can think of!

I’ve edited all cell references so it’s obvious where they lie; and not what they refer to. Personally I find cognitive search-and-replace really frustrating, and Excel has never made debugging input to its formula bar easy (I can only imagine the frustration a command-line PHP dev’ must have!)…

The magic started life as:

=IF(OR(I6="",K6=""),"?",NETWORKDAYS(I6,K6,))

Designed around NETWORKDAYS to figure out the amount of time between two user-defined dates; it makes a nominal effort to filter out bad data. Read More…