Not equal to?
 

I have a form that compares the total values of several fields to a variable
value when the user clicks the Submit button. The fields need to equal the
variable value or the form will not be submitted. I ran into a problem where
the fields DO appear to equal the variable value, but excel says no....In
the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate this
problem with other random numbers. I get back TRUE when using other values.
I obviously have not tried every value, but I am lost for now. Any ideas
where I might start?

Thanks

Not equal to?
 

Try

?Round(salecomm,2) = 1228.95

it is probably because the actual value is 1228.95243357 or something, but
only showing 2 dec places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
I have a form that compares the total values of several fields to a
variable
value when the user clicks the Submit button. The fields need to equal the
variable value or the form will not be submitted. I ran into a problem
where
the fields DO appear to equal the variable value, but excel says no....In
the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate this
problem with other random numbers. I get back TRUE when using other
values.
I obviously have not tried every value, but I am lost for now. Any ideas
where I might start?

Thanks

Not equal to?
 

Thanks, this solved the problem. Strange though, I have been using this
spreadsheet for years. The user enters a total value, which is stored as a
variable. The user then enters a subtotal, and is given the difference
between the total and the subtotal to confirm. It is then stored as another
variable. The numbers are ALWAYS whole numbers, or numbers with two decimal
places. I have not run into this problem with thousands of transactions.

For what it's worth, this was all written in Excel 2000. I upgraded to Excel
2002 and used it with no trouble for a couple of years with no problem. I
recently upgraded to Excel 2003. I can no longer use the file in 2000 or
2002 since saving it as 2003 because I get a lot of "object not found"
messages for code that I have not changed.

"Bob Phillips" wrote in message
...
Try

?Round(salecomm,2) = 1228.95

it is probably because the actual value is 1228.95243357 or something, but
only showing 2 dec places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
I have a form that compares the total values of several fields to a
variable
value when the user clicks the Submit button. The fields need to equal
the
variable value or the form will not be submitted. I ran into a problem
where
the fields DO appear to equal the variable value, but excel says
no....In
the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate this
problem with other random numbers. I get back TRUE when using other
values.
I obviously have not tried every value, but I am lost for now. Any ideas
where I might start?

Thanks

Not equal to?
 

Evan,

Can't offer much help as I don't have Excel 2003, but it does sound strange.

Perhaps someone else has experienced this and understands it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
Thanks, this solved the problem. Strange though, I have been using this
spreadsheet for years. The user enters a total value, which is stored as a
variable. The user then enters a subtotal, and is given the difference
between the total and the subtotal to confirm. It is then stored as
another
variable. The numbers are ALWAYS whole numbers, or numbers with two
decimal
places. I have not run into this problem with thousands of transactions.

For what it's worth, this was all written in Excel 2000. I upgraded to
Excel
2002 and used it with no trouble for a couple of years with no problem. I
recently upgraded to Excel 2003. I can no longer use the file in 2000 or
2002 since saving it as 2003 because I get a lot of "object not found"
messages for code that I have not changed.

"Bob Phillips" wrote in message
...
Try

?Round(salecomm,2) = 1228.95

it is probably because the actual value is 1228.95243357 or something,
but
only showing 2 dec places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
I have a form that compares the total values of several fields to a
variable
value when the user clicks the Submit button. The fields need to equal
the
variable value or the form will not be submitted. I ran into a problem
where
the fields DO appear to equal the variable value, but excel says
no....In
the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate
this
problem with other random numbers. I get back TRUE when using other
values.
I obviously have not tried every value, but I am lost for now. Any
ideas
where I might start?

Thanks

Not equal to?
 

The "object not found" error has nothing to do with the code. Rather it
has to do with the infrastructure required to run VBA. Copy the VBA
code to Notepad and delete the modules. Then in Excel 2000 insert
modules and past the code from Notepad.

I have seen no evidence that the numerics have changed in 2003. I use
all three versions (Excel 2000, 2002, and 2003) if you want to post the
code (text only, not attachments).

Jerry

Evan wrote:

Thanks, this solved the problem. Strange though, I have been using this
spreadsheet for years. The user enters a total value, which is stored as a
variable. The user then enters a subtotal, and is given the difference
between the total and the subtotal to confirm. It is then stored as another
variable. The numbers are ALWAYS whole numbers, or numbers with two decimal
places. I have not run into this problem with thousands of transactions.

For what it's worth, this was all written in Excel 2000. I upgraded to Excel
2002 and used it with no trouble for a couple of years with no problem. I
recently upgraded to Excel 2003. I can no longer use the file in 2000 or
2002 since saving it as 2003 because I get a lot of "object not found"
messages for code that I have not changed.

"Bob Phillips" wrote in message
...

Try

?Round(salecomm,2) = 1228.95

it is probably because the actual value is 1228.95243357 or something, but
only showing 2 dec places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
.. .

I have a form that compares the total values of several fields to a

variable

value when the user clicks the Submit button. The fields need to equal

the

variable value or the form will not be submitted. I ran into a problem

where

the fields DO appear to equal the variable value, but excel says

no....In

the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate this
problem with other random numbers. I get back TRUE when using other

values.

I obviously have not tried every value, but I am lost for now. Any ideas
where I might start?

Thanks