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
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
 
Ad

Advertisements

Ad

Advertisements

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top