Try this:

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

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

=3DIF(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=20
need to have a=20
programmer take this on.=20
Here goes, I need to keep track of driver total hours.=20
Drivers cannot work=20
over a certain number of hours in a week. There are two=20
shifts an AM sign on=20
and sign off time plus a PM sign on and sign off time. To=20
complicate this=20
each driver is guaranteed a minimum of 2.25 hours for=20
both AM and PM shifts.=20
I am using an IF function to validate the value of a cell=20
based on the amount=20
of time for each shift. I use a formula to calculate the=20
difference between=20
the sign off and sign on times and put that value in a=20
cell then check to see=20
if the value meets certain conditions.

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

.