The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Medium Priority · Version 2003

ReplyTue 23 Feb 2010, 10:10Delegate Christina said...

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

For upcoming training course dates see: Pricing & availability

ReplyTue 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

Regards

Stephen

Excel articles

· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Create Date Sensitive Colour Changing Cells In Excel
· How To Use Excel To Create Large SQL Insert Statements
· Mastering Page Layout In Excel
· Radio Buttons And Check Boxes In Excel

Please browse our web site to find out more about
training in excel and other Microsoft training courses.

Excel tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

View all Excel hints and tips

How to check why a formula isnt working?

» Forum post: IF

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London