ExcelBanter - function help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - function help (https://www.excelbanter.com/excel-worksheet-functions/50404-function-help.html)

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
--
paul
remove nospam for email addy!

"fomula problems" wrote:

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