Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula help
I am VERY new to spreadsheets! Is there a formula that will calculate the %
change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan |
#2
|
|||
|
|||
Hi Susan,
Very clear! assuming Jan in A1, Feb in B1, Mar in C1, etc. enter this in B2 =(B1-A1)/A1 and format as a a percentage, then just copy across If you want to setup for the year, use =IF(B1="","",(B1-A1)/A1) -- HTH RP (remove nothere from the email address if mailing direct) "Susan" wrote in message ... I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan |
#3
|
|||
|
|||
I think this will work! I'll try it next week and let you know how I do!
Thanks! -- Susan "Bob Phillips" wrote: Hi Susan, Very clear! assuming Jan in A1, Feb in B1, Mar in C1, etc. enter this in B2 =(B1-A1)/A1 and format as a a percentage, then just copy across If you want to setup for the year, use =IF(B1="","",(B1-A1)/A1) -- HTH RP (remove nothere from the email address if mailing direct) "Susan" wrote in message ... I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan |
#4
|
|||
|
|||
Susan,
Suggest starting a new thread if it doesn't -- HTH Bob Phillips "Susan" wrote in message ... I think this will work! I'll try it next week and let you know how I do! Thanks! -- Susan "Bob Phillips" wrote: Hi Susan, Very clear! assuming Jan in A1, Feb in B1, Mar in C1, etc. enter this in B2 =(B1-A1)/A1 and format as a a percentage, then just copy across If you want to setup for the year, use =IF(B1="","",(B1-A1)/A1) -- HTH RP (remove nothere from the email address if mailing direct) "Susan" wrote in message ... I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's value of a stock is $10, and February's value is $12, and March's value is $6, can I get a cell that will show a 20% increase for Feb, and change to (50%) loss when I enter March's value? I hope this is clear! Thanks for any help! Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |