Automatic input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pop up message 1
Adding up total hours worked on employee schedule using various criteria 0
Default Number 1
If, then formula to capture data? 2
How do I change the format to allow a zero as a first digit? 3
Multi YTD Summary 3
Employee Scheduling Worksheet 10
Is this even possible?? 1

Back
Top