Dave your a genius, that worked fine. It returns whatever is in cell E11.

Thanks everyone for your assistance.

"Dave Ramage" wrote:

Try this:

=IF(ISNUMBER(E11),IF(E11$E$5,E11,$E$11),"")

If the value in E11 is non-numeric then an empty string is
returned. You could also use this to return zero instead:

=IF(ISNUMBER(E11),IF(E11$E$5,E11,$E$11),0)

Cheers,
Dave
-----Original Message-----
This is a rather complex issue so I will understand if I
need to have a
programmer take this on.
Here goes, I need to keep track of driver total hours.
Drivers cannot work
over a certain number of hours in a week. There are two
shifts an AM sign on
and sign off time plus a PM sign on and sign off time. To
complicate this
each driver is guaranteed a minimum of 2.25 hours for
both AM and PM shifts.
I am using an IF function to validate the value of a cell
based on the amount
of time for each shift. I use a formula to calculate the
difference between
the sign off and sign on times and put that value in a
cell then check to see
if the value meets certain conditions.

If the value returned is grater than 2.25 I place the
grater value in
another cell. If the value is less than 2.25 I place 2.25
in the cell. I then
total the AM and PM times and get the number of hours the
driver worked that
day. The IF function looks like thisâ?¦=IF
(E11=F5,E11,"2.25"). F5 contains the
value 2.25, the check value. My problem is that the value
2.25 is returned on
non data or an empty cell. The IF function evaluates non
data or an empty
cell to be les than 2.25 thus returning 2.25 giving hours
where there should
not be any for that time period.
Is there a way to create a validation that will ignore an
empty cell until
data is supplied?
I apologize for this being so long winded.

.