function help

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

Guest

I want to enter the time in each of the cells of one row, each cell that gets
a time i want another column to indicate yes if a time is entered or no if
the cell is blank.This would be entered in the row coresponding to were the
time was entered, like enter the time in cell B2 or leave blank and in cell
K2 would appear a Yes or No, hope this is clear to anyone who can help.
Alan
 
in K2 type =if(B2<>"","yes",no).If you type anything in b2(time or not) k2
will say yes,otherwise (ie if b2 is blank) it will show no
 
You must log in or register to reply here.

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

Sumproduct not working 5
Comparison of columns using Conditional Formatting 3
Time & Date Formulas 7
use month in cell date to sum all relevant cells 2
Staff Overtime Form 2
formula to show time that data was entered on spreadsheet 1
Current Time Function 11
showing an empty cell instead of a zero in a formulated cell. 1

Back
Top