Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |