LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can I make cell "yes" equal 1, "no" equal 0 can I make cell yes equal 1, no equa Excel Discussion (Misc queries) 4 April 22nd 23 06:09 AM
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) Red Herald Excel Worksheet Functions 2 November 13th 08 12:11 AM
#ref to equal zero cherrynich Excel Worksheet Functions 2 February 6th 06 09:31 PM
Contains instead of Equal Jennifer Excel Worksheet Functions 4 September 13th 05 03:42 PM
Getting 0 to equal 1 soxn4n04 Excel Worksheet Functions 9 November 30th 04 04:15 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"