Help with IF function please 03.08.08

[Bob Phillips]

I doubt it is more efficient. Obfuscated, certainly.

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.

 

[Tyro]

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

 

[Bob Phillips]

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)

 

[Essjay]

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