Home |
Search |
Today's Posts |
#1
|
|||
|
|||
function help
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |