Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
Hi There, I have a number of formulars for example =SUM(B2/C2) in Cell D9 how do i get a macro to calculate all of these for me and put the answer in D9 for me. A list of some others Current Ratio =SUM(B2/C2) Total Asset Turnover =SUM(K2/L2) Debt-to-Equity =SUM(C2+O2)/P2 Dividend Per Share =SUM(T2/S2) Luqid Ratio =SUM(B2-I2)/(C2-F2) Thanks Heaps Thanks Heaps -- redlion ------------------------------------------------------------------------ redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140 View this thread: http://www.excelforum.com/showthread...hreadid=560934 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
Not sure what you mean, but if you have a formula in a cell, it returns a
value. So, your cell D9 will show the result of the formula. Not sure how/why you want all these results in D9; makes no sense. Also, in these formulae, you use SUM. As you only have single arguments, SUM serves no purpose here. NickHK "redlion" wrote in message ... Hi There, I have a number of formulars for example =SUM(B2/C2) in Cell D9 how do i get a macro to calculate all of these for me and put the answer in D9 for me. A list of some others Current Ratio =SUM(B2/C2) Total Asset Turnover =SUM(K2/L2) Debt-to-Equity =SUM(C2+O2)/P2 Dividend Per Share =SUM(T2/S2) Luqid Ratio =SUM(B2-I2)/(C2-F2) Thanks Heaps Thanks Heaps -- redlion ------------------------------------------------------------------------ redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140 View this thread: http://www.excelforum.com/showthread...hreadid=560934 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
Sorry NickHK, All I need is a macro which uses this formula =SUM((D2+E2))/2*(365)/J and put the answer in cell E9 Regard -- redlio ----------------------------------------------------------------------- redlion's Profile: http://www.excelforum.com/member.php...fo&userid=3614 View this thread: http://www.excelforum.com/showthread.php?threadid=56093 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
Why not just put the formula in E9:
=SUM((D2,E2))/2*(365)/J2 Note, you do not need "SUM" and "+". One or the other. NickHK "redlion" wrote in message ... Sorry NickHK, All I need is a macro which uses this formula =SUM((D2+E2))/2*(365)/J2 and put the answer in cell E9 Regards -- redlion ------------------------------------------------------------------------ redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140 View this thread: http://www.excelforum.com/showthread...hreadid=560934 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
Because I would like it Macro driven so other uses can not stuff up the formulars, but I Got Thanks Mate Sub Ratio() Sheets("data").Select Range("E21").Value = Evaluate("=SUM((D2+E2))/2*(365)/J2 ") End Sub -- redlion ------------------------------------------------------------------------ redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140 View this thread: http://www.excelforum.com/showthread...hreadid=560934 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro
That's why you can Protect the worksheet.
NickHK "redlion" wrote in message ... Because I would like it Macro driven so other uses can not stuff up the formulars, but I Got Thanks Mate Sub Ratio() Sheets("data").Select Range("E21").Value = Evaluate("=SUM((D2+E2))/2*(365)/J2 ") End Sub -- redlion ------------------------------------------------------------------------ redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140 View this thread: http://www.excelforum.com/showthread...hreadid=560934 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |