1.#QNAN In Field

J

JESwan

Anyone ever see this displayed in a calcuated field.
I have a cell that is populated by 1 of 6 rules based on another cell.

Example

Cell 1 Cell 2
If Cell 1 Btwn 1 -10 Cell 2 Value is .05
If Cell 1 Btwn 11-20 Cell 2 Value is .10
If Cell 1 Btwn 21-30 Cell 2 Value is .15

A basic percentag discount thing...
For some reason the .05 (5%) always throws the 1.#QNAN value after the data
has been saved (Access 2003) and re-displayed in the form.
All the other rules work fine..

Anyone ever seen this 1.#QNAN value, and where it comes from

TIA.
Jay
 
J

JESwan

Just noticed one other thing...
The problem seems to be when I do the following calculation.

(1.00 - @DiscountValue) * (@UnitPrice * @Quantity)
The only discount value to throw the odd text error is .05 (or 5%)
All others work fine...
 

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

Similar Threads

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to Create an S-Curve from Custom Field? 0
MS Project Import Error Row 1 Column 5 2
Auto populate value from one task to another in MS PROJECT 0
Menu Macro Not Executing - Need Help 1
conditional format fails when copied 1

Top