require a change in formula

[Sathisc]

Hi,

I am currently using a formula
=IF(I11<TIME(14,0,0),100%,0%) find the the % and whether the job is
done before 14:00

problem is when i dont enter any data also it shows 100% which is
affecting my chart. I need the formula to calculate only when i enter
data in the relevant field.

can any one help me in this issue.

 

[RagDyeR]

Try this:

=IF(AND(I11<>"",I11<TIME(14,0,0)),100%,0%)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



Hi,

I am currently using a formula
=IF(I11<TIME(14,0,0),100%,0%) find the the % and whether the job is
done before 14:00

problem is when i dont enter any data also it shows 100% which is
affecting my chart. I need the formula to calculate only when i enter
data in the relevant field.

can any one help me in this issue.

 

[Fred Smith]

Try it this way:

=if(i11="","",if(i11<time(14,0,0),100%,0%))

or, shorter:
=if(i11="","",if(i11<--"14:00",1,0))

Regards,
Fred.

 

[Sathisc]

Thanks guys

 

[Pecoflyer]

Glad we could be of help!