Conditional formating Confusion

S

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

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

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

R

roccogrand

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

LDN

S

Steve B

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

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

LDN

Steve B said:
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

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

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