L
lotus lover
Hi. I hope you can help me out. I'm dealing in clock time. I've written the
formula
=if(AN7<.375,.375 If (AN7>=.375,AN7))
So, if the content of cell AN7 is before 9:00AM, the formula cell posts
9:00AM and if the content of cell AN7 is later than 9:00AM, the formula cell
posts that time.
The problem is if cell AN7 is blank. The formula cell is now posting
9:00AM, i assume because I have no greater than 0 statement. What I want is
for the formula cell to post blank, or at worse "false".
Is this doable?
formula
=if(AN7<.375,.375 If (AN7>=.375,AN7))
So, if the content of cell AN7 is before 9:00AM, the formula cell posts
9:00AM and if the content of cell AN7 is later than 9:00AM, the formula cell
posts that time.
The problem is if cell AN7 is blank. The formula cell is now posting
9:00AM, i assume because I have no greater than 0 statement. What I want is
for the formula cell to post blank, or at worse "false".
Is this doable?