LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Why doesn't Excel allow conditional formats to be saved after cer. Guatama100 Excel Discussion (Misc queries) 1 January 5th 06 01:27 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
how do I apply more than 3 conditional formats in excel chetwyndthomas Excel Discussion (Misc queries) 1 January 30th 05 04:24 PM
Is it possible to do a conditional subtotal in Excel? LTS_Bgobien Excel Worksheet Functions 6 November 16th 04 11:12 PM


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"