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
|