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?
--
craig phila

Try:
=IF(AN7="","",IF(AN7<0.375,0.375,IF(AN7=0.375,AN7 )))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lotus lover" wrote:
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?
--
craig phila

And of course you don't need the AN7=0.375 test, because you've earlier
tested for AN7<0.375.

=IF(AN7="","",IF(AN7<0.375,0.375,AN7))
or
=IF(AN7="","",MAX(0.375,AN7))
--
David Biddulph

"Max" wrote in message
...
Try:
=IF(AN7="","",IF(AN7<0.375,0.375,IF(AN7=0.375,AN7 )))

"lotus lover" wrote:
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?
--
craig phila

"David Biddulph" <groups [at] biddulph.org.uk wrote:
=IF(AN7="","",IF(AN7<0.375,0.375,AN7))
or
=IF(AN7="","",MAX(0.375,AN7))

Yes. Thanks for refinements, David.
Guess I was too hung up with the front IF part of it <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

thanx max
--
craig phila


"Max" wrote:

"David Biddulph" <groups [at] biddulph.org.uk wrote:
=IF(AN7="","",IF(AN7<0.375,0.375,AN7))
or
=IF(AN7="","",MAX(0.375,AN7))

Yes. Thanks for refinements, David.
Guess I was too hung up with the front IF part of it <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

thnax so much. works exactly right.
--
craig phila


"David Biddulph" wrote:

And of course you don't need the AN7=0.375 test, because you've earlier
tested for AN7<0.375.

=IF(AN7="","",IF(AN7<0.375,0.375,AN7))
or
=IF(AN7="","",MAX(0.375,AN7))
--
David Biddulph

"Max" wrote in message
...
Try:
=IF(AN7="","",IF(AN7<0.375,0.375,IF(AN7=0.375,AN7 )))

"lotus lover" wrote:
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?
--
craig phila

Welcome, Craig.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lotus lover" wrote in message
...
thanx max
--
craig phila