Help with IF function please 03.08.08

  • Thread starter Thread starter Essjay
  • Start date Start date
Tyro said:
I doubt it is more efficient. Obfuscated, certainly.
Click to expand...


Well I am afraid you are just plain wrong there.

I just timed it and Biff''s is 31% faster than Sean's first formula, and 41%
faster than yours. By my reckoning that is more efficient.
 
I don't think that execution time should take predence over the
understanding of a simple formula. How much time is involved here. 10
microseconds? 20 microseconds, 5 days?

Tyro
 
That is another argument. You said, and I quote, ... I doubt it is more
efficient.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Roger
Thanks for the comprehensive answer. You're correct in that my query does
deal with UK VAT. The only reason I used the letters V & E was more as an
"aide memoire" for the person doing the input ~ V to stand for VATable and E
for Exempt. The VAT element will only ever fall into the customary standard
17.5% (unless otherwise amended by HMG!), or be Exempt, so I was trying to
apply the KISS principle to the formula. I will re-jig the columnisation to
reflect your suggestion.
I'd just like to thank everyone for the time they've taken with my query and
for sharing their knowledge so readily.
Regards
Essjay
 
Back
Top