View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Percentage Help Please

Try this:

=20.5*1.023

Resturns 20.9715

You might want to round to 2 decimal places:

=ROUND(20.5*1.023,2)

Returns 20.97

--
Biff
Microsoft Excel MVP


"Caz" wrote in message
...
Please Help me, I am new to this and I am pulling my hair out. Can someone
please tell me what formula I need to type in to get the answer to the
below:
cost price plus 2.3% equals

£20.50 + 2.3% =