#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default percentages

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default percentages

Please give us what values are where and what needs to be worked upon.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PERCENTAGES Pnw Excel Worksheet Functions 3 August 19th 08 10:30 PM
percentages adstarc New Users to Excel 8 October 15th 07 03:07 PM
percentages kthornton Excel Discussion (Misc queries) 1 May 30th 06 11:42 PM
Percentages Vince Carlese Excel Discussion (Misc queries) 9 June 29th 05 09:04 PM
Percentages Darryl Charts and Charting in Excel 2 May 21st 05 04:31 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"