hi i am trying to add 17.5% (VAT) to a cell by using =sum(h10)+17.5%
h10 being the price without vat and the formula is in the Including Vat cel
but it does not seem to work
any suggestions?
hi i am trying to add 17.5% (VAT) to a cell by using =sum(h10)+17.5%
h10 being the price without vat and the formula is in the Including Vat cel
but it does not seem to work
any suggestions?
try thisOriginally Posted by Radonsheep
=H10+0.175*H10
Try this,
=H10*1.175
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thanks alot - worked like a charm!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks