Automatic input

H

HRlady

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
 
H

HRlady

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
 
A

AKphidelt

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