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

how to creat a formual that show a increase value of a number if that number
was increase by a precent
what is the basic formual
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default excels formuals

If you have an original value in A1 and a percentage increase in B1
(formatted as percentage), then the increased value =A1*(1+B1)
If B1 contains the percentage as a number (such as 10, rather than 10%),
then the formula is =A1*(1+B1%)
--
David Biddulph

"jvenditti" wrote in message
...
how to creat a formual that show a increase value of a number if that
number
was increase by a precent
what is the basic formual



  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default excels formuals

Perhaps a simple example will illustrate it ..
In A2 down are the source numbers, eg: 100, 200, etc
In B2 down are the percentage increases for each source number,
eg: 10%, 15%, ... (note that these are entered with the "%" sign)

You could put in C2: =A2*(1+B2)
and copy C2 down to return the required results
Any good? hit the YES below
--
Max
Singapore
xde
---
"jvenditti" wrote:
how to creat a formual that show a increase value of a number if that number
was increase by a precent
what is the basic formual

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
Formuals Gene McKinney YMCA international Excel Discussion (Misc queries) 2 April 30th 08 08:09 PM
New to Formuals Tanya Excel Worksheet Functions 2 May 12th 07 04:30 AM
formuals in comments in excel u9946675 Excel Discussion (Misc queries) 1 October 26th 06 11:59 AM
Many Excels To one Neg5vu Excel Worksheet Functions 1 August 1st 05 02:21 PM
Excels 97 sr-2 where? COW my Initials Excel Discussion (Misc queries) 4 December 31st 04 09:09 PM


All times are GMT +1. The time now is 04:49 AM.

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

About Us

"It's about Microsoft Excel"