Ha.
--
Brevity is the soul of wit.


"JLatham" wrote:

This is another of those cases where someone asks someone else to do
something, and then wants to direct how it gets done. Seems the task has
been accomplished, and if it works, it works.

Kind of like someone asking you to design an incandescent light, and when
you do, they tell you it's too complicated to use because they don't
understand electricity.

If your boss reads this and doesn't like it, tell him to feel incredibly
free to fire me without notice. But he may need to keep you around the tell
him how electricity works for a while longer yet...

"Dave F" wrote:

Well, it makes sense but I'm not sure that it's any more concise which seems
to have been the original concern.

But thanks for the suggestion.

Dave
--
Brevity is the soul of wit.


"pinmaster" wrote:

Hi,

Just checking but does this make sense:

=IF(MAX(H11:G11)*99%<=MIN(H11:G11),"valid","invali d")

Regards!
Jean-Guy

"Dave F" wrote:

The formula above tests to make sure that H11 and G11 differ by less than 1%.

And yet the spreadsheet the formula is in was returned to me by my boss'
boss...saying "this formula makes no sense!" Despite the fact that it does.

So....is there a cleaner way of doing the same calculation?

Dave
--
Brevity is the soul of wit.