| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic input
Again, working on putting a employee schedule together. How do I set it up so
that when the word "Off" is inputing into the schedule column the total column (the one next to it) automatically inputs zero? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic input
Maybe this will work for you
=IF(A1="OFF","0","") "HRlady" wrote: Again, working on putting a employee schedule together. How do I set it up so that when the word "Off" is inputing into the schedule column the total column (the one next to it) automatically inputs zero? Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic input
I am so sorry but I am not very Excel literate...where do I pu that formula in the column with the Off or the column with the total. Also, what if there is already a formula in the total column? Thanks "Mike" wrote: Maybe this will work for you =IF(A1="OFF","0","") "HRlady" wrote: Again, working on putting a employee schedule together. How do I set it up so that when the word "Off" is inputing into the schedule column the total column (the one next to it) automatically inputs zero? Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic input
Ok, if you are not excel literate when you post questions, make sure to
include all the information you can... like what columns or cells are being used. Otherwise it's hard to explain exactly what to do. In this case, like Mike says... use the IF function in the column next to the cell that could contain the word "OFF". The IF function goes... IF("Reference", "Value if true", "Value if False") So in this case, if there is a formula in the column already... say something like IF(A1="OFF",0,PreviousFormula) Do not type in the words previous formula, actually input the formula that was used. "HRlady" wrote: I am so sorry but I am not very Excel literate...where do I pu that formula in the column with the Off or the column with the total. Also, what if there is already a formula in the total column? Thanks "Mike" wrote: Maybe this will work for you =IF(A1="OFF","0","") "HRlady" wrote: Again, working on putting a employee schedule together. How do I set it up so that when the word "Off" is inputing into the schedule column the total column (the one next to it) automatically inputs zero? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic data input | Excel Discussion (Misc queries) | |||
| Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
| automatic input of cell values | Excel Worksheet Functions | |||
| mostly automatic input | Excel Discussion (Misc queries) | |||
| How do I input for an automatic increment in a cell on Excel? | Excel Worksheet Functions | |||
Hybrid Mode
