RE: formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vacation's Over <VacationsOver@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 5 Aug 2005 08:03:07 -0700

your english is better than my German

Try looking at the worksheet change event
and add something like....
if target is in column a then
if target is = cs16 then
' "do the division"

"zipdrivemegabite" wrote:

> In excel I am trying to find in the help program to setup my spreadsheet. I
> am doing a acumulation, I have setup each colum to all up a total. I need to
> know the formula to setup when a certain description (exp: CS16) in enter in
> colum A in any roll. It will automatically divied into a certain amount
> (exp: 150) I have read serveral differant topics and cannot find the right
> formula to complete my spread sheet.
.

References:
- formula
  - From: zipdrivemegabite

Prev by Date: Passing Strucutres from VBA to DLL and back
Next by Date: Re: Insert Date that Macro runs
Previous by thread: formula
Next by thread: Error inserting formulas into a range object
Index(es):
- Date
- Thread

Relevant Pages

formula
... In excel I am trying to find in the help program to setup my spreadsheet. ... I have setup each colum to all up a total. ... (exp: 150) ...
(microsoft.public.excel.programming)
RE: Follow up for Mike H or J Latham
... shown below in EXP 1. ... being gone that enters that value - the Target Value formula fails. ... Private Sub Worksheet_Change ... Page" (Front Page linked to Data Page "B5" Cell). ...
(microsoft.public.excel.misc)
Re: Adding TARGETDIR for web project using ORCA is not working
... [MVP Windows Installer] ... I created a Web setup project using VS 2003 and edited the output msi ... target directory, as specified during installation, but the virtual ...
(microsoft.public.vsnet.setup)
Re: ADMT v3 Error
... setup, with the exception that I am running ADMT v3 from the target DC. ... I am unable to add users to the Local Administrator ... Ive also been trying to test with a group migration and get the same ...
(microsoft.public.windows.server.migration)
Re: xPC + RS232 Asyncronous Receive
... This sounds like you may have some more fundamental problems ... The slprj directory should be created in the current directory. ... This is not an xPC Target ... If I continue with this setup, will I be able to run a Simulink model in real time....not the "simulated time" that simulink models are usually run. ...
(comp.soft-sys.matlab)