Help with IF function please 03.08.08

B

Bob Phillips

Tyro said:
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.
 
T

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
 
B

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)
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top