VAT formula

S

Sandy Mann

=B42*17.5%

or:

=B42*0.175
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
E

eddiethemini

Thank you, I used the second one but it left a % sign, I forgot you could do
it the easier way! its a lot of years since I did a spreadsheet course.
 
S

Sandy Mann

You're very welcome. Thanks for the feedback

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Writing Formula For conditional Formatting Using Excel 2000 3
Entering an If formula using conditional formatting 2
Please help - formula for percentage 2
If date in range is before today 3
Help with a formula 4
Multiple Nested IFs, ORs, Ands 5
how to add 17.5% vat formula 7
Simple, if you know Excel !!!! 5

Top