ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   formula (https://www.excelbanter.com/excel-programming/336443-formula.html)

zipdrivemegabite

formula
 
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.

Vacation's Over

formula
 
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.



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com