Thread: percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default percentages

If Cost is in B1 and percentage in B2
Then this in A1
=B1*(1+B2) will give you the Charge

So if B1 is 100 and B2 is 30% then Charge would be 130. Is that what you
were looking for?
If not then pl. give the values in B1 and B2 and the expected value in A1.

"confused deejay" wrote:

can some one please help before i go insane

i'm trying to work out cost using percentage what i want to do is...

a1 charge b1 cost b2 %

i want a sum to work out what the charge is if cost is 100 and % is 30

i need the sum because % changes for each item

cheers confused deejay x
--
deejay