View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge[_2_] Nick Hodge[_2_] is offline
external usenet poster
 
Posts: 185
Default how do i get to discount 10% of a bill

Dermot

you don't need the sum, but add *.9 at the end, e.g.

=(D4*F4)*.9

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"dermot martin cleary" <dermot martin
wrote in message ...
If someone is staying in a hotel for two nights @ ‚¬80 per night.I go
=sum(d4*f4)enter and get ‚¬160 how do i then give a 10% discount ?.