98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Medium Priority · Version 2003
Tue 23 Feb 2010, 10:10Delegate Christina said...
Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Formulas
I am trying to write the below formula;
=MID(A21,2,1), (B22*17.5%)
Basically I want the first part of the formula to pull through the currency selected either £/$/€, then the second part of the formula is working the VAT element.
Can this be done??
Kind regards,
C Christoforou
Tue 23 Feb 2010, 14:08Trainer Stephen said...
RE: Formulas
Hi Christina
Thanks for the question
I need to see this formula in context to be able to answer adequately
Could you email me a copy, perhaps with the data changed if it is confidential. I will then analyse the problem and get you a reply
My email is sw@stl-training.co.uk
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
