Thread: working with %
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default working with %

You are really doing

..49 - .10 - .025 - .1350 = .23

Make sure you percentages are number (not string) and your currency is
formated as pound (not string).


"Kirk" wrote:

Hi,

I am trying to work out a value.

A1 A2 A3 A4 A5
£0.49 10.00% 2.50% 13.50% ?

A5 needs to calculate A1 - A2 -A3 -A4

I cant get it to work. Please help