Conditional formating Confusion

[Steve B]

Evening all.

Access 2000

I didnt' think my math was too bad but I'ms stuck in a rut with this
formating issue.

I have a field that is a basic sum of other fields shown below

=IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
Secs]))))/([Inbound Calls Answered]))

I'ts basicaly realtime data from a Telephone switch to show how fast calls
are answered

The current result in the field gives an answer of 0.0909090909090909 which
as a percentage is 9.09% using the percent format

Under conditional formating I have the following criteria

Condition 1
Field Value is - [less than or equal to] - 0.79 Colour the cell RED

Condition 2
Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN

Now at the moment the 0.90909 result is turning the cell Green, when it
should be red.

I've used the same data in Excel, with the same formating and it works
correctly?

Any idea's

 

[roccogrand]

What is the conditional formatting evaluating 0.09, 0.90, or 9.09?

LDN

 

[Steve B]

It's evaluating >= .8 and <= .799

What is the conditional formatting evaluating 0.09, 0.90, or 9.09?

LDN

Evening all.

Access 2000

I didnt' think my math was too bad but I'ms stuck in a rut with this
formating issue.

I have a field that is a basic sum of other fields shown below

=IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
Secs]))))/([Inbound Calls Answered]))

I'ts basicaly realtime data from a Telephone switch to show how fast
calls
are answered

The current result in the field gives an answer of 0.0909090909090909
which
as a percentage is 9.09% using the percent format

Under conditional formating I have the following criteria

Condition 1
Field Value is - [less than or equal to] - 0.79 Colour the cell RED

Condition 2
Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN

Now at the moment the 0.90909 result is turning the cell Green, when it
should be red.

I've used the same data in Excel, with the same formating and it works
correctly?

Any idea's