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

Formulas

ResolvedVersion 2003

Tue 23 Feb 2010, 10:10 Delegate 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:08 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Viewing two Excel 2010 Workbooks at the same time