Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Excel Iterations? Conditional Operations?
I've only used excel a few times, and what I've read so far doesn't
tell me if this is possible, tho' I have to assume it is. Is it possible to assign a formula to a column, say, and have the entire column be set to a formula with the values of other columns on a row-by-row basis? That is, something like Cx=Ax+Bx. And since I want it to be able to handle odd situations, like the absence of some entries, to set tests -- like set a variable to some value if the cell has no entry, or has, say, a letter instead of a number? The sort of thing I could do in APL? Would this require some sort of additional package to install in Excel? Or does excel do this by itself? Thanks! Mark |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Excel Iterations? Conditional Operations?
You can construct quite complex formulae using standard Excel Functions, if
all else fails you can write your own function in a VBA module to use on the sheet. But beware user written functions are slower than the built in functions and tests. Try to stay with the built in functionality unless you are only going to put your function in a small number of cells -- Tony Green " wrote: I've only used excel a few times, and what I've read so far doesn't tell me if this is possible, tho' I have to assume it is. Is it possible to assign a formula to a column, say, and have the entire column be set to a formula with the values of other columns on a row-by-row basis? That is, something like Cx=Ax+Bx. And since I want it to be able to handle odd situations, like the absence of some entries, to set tests -- like set a variable to some value if the cell has no entry, or has, say, a letter instead of a number? The sort of thing I could do in APL? Would this require some sort of additional package to install in Excel? Or does excel do this by itself? Thanks! Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Iterations? Conditional Operations?
It is definately possible and not too difficult, if you explain the problem more specifically, you will probsbly get an answer. Give an example, with some data and what you would like to happen in the exception situations Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=546620 |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Excel Iterations? Conditional Operations?
What you are asking is standard stuff in Excel.
As you think, a cell, say C2 can be set to =A2+B2 and that can be copied down as far as you want. Tests can be added, =IF(A"<"",A2+B2,"No data in column A") or even more complex =IF(AND(A2<"",B2<""),A2+B2,"Invalid data") It can get much, much more complex than that. Most requirements can be met with functions, but if not, there is always VBA to extend it even further. -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) wrote in message oups.com... I've only used excel a few times, and what I've read so far doesn't tell me if this is possible, tho' I have to assume it is. Is it possible to assign a formula to a column, say, and have the entire column be set to a formula with the values of other columns on a row-by-row basis? That is, something like Cx=Ax+Bx. And since I want it to be able to handle odd situations, like the absence of some entries, to set tests -- like set a variable to some value if the cell has no entry, or has, say, a letter instead of a number? The sort of thing I could do in APL? Would this require some sort of additional package to install in Excel? Or does excel do this by itself? Thanks! Mark |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Excel Iterations? Conditional Operations?
Hi
In C1 enter something like =IF(COUNTA(A1:B1)=0,"",IF(AND(ISNUMBER(A1),ISNUMBE R(B1)),A1+B1,"something else") Clearly the "something else" can be further tests, or a value you want to be inserted. Copy C1 down column C as far as you wish. -- Regards Roger Govier wrote in message oups.com... I've only used excel a few times, and what I've read so far doesn't tell me if this is possible, tho' I have to assume it is. Is it possible to assign a formula to a column, say, and have the entire column be set to a formula with the values of other columns on a row-by-row basis? That is, something like Cx=Ax+Bx. And since I want it to be able to handle odd situations, like the absence of some entries, to set tests -- like set a variable to some value if the cell has no entry, or has, say, a letter instead of a number? The sort of thing I could do in APL? Would this require some sort of additional package to install in Excel? Or does excel do this by itself? Thanks! Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Why doesn't Excel allow conditional formats to be saved after cer. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions |