Excel 98 not functioning properly on formula
Ok this is strange, I export my beautiful clean sub to a 98 machine and
when it calculates a basic if statement, it does not caluculate properly. Example, =IF(B2=10,"GOOD","BAD") On the 98 machine it returns BAD even if B2=10, this works fine on my Excel2003, and does not work on the Excel98 machine. Anyone ever run in to this....the formula is definetly right! Confused, Mike *** Sent via Developersdex http://www.developersdex.com *** |
Excel 98 not functioning properly on formula
Most likely situation is that B2 contains the String 10 and not the number
10. It makes a difference. -- Regards, Tom Ogilvy "Michael Smith" wrote in message ... Ok this is strange, I export my beautiful clean sub to a 98 machine and when it calculates a basic if statement, it does not caluculate properly. Example, =IF(B2=10,"GOOD","BAD") On the 98 machine it returns BAD even if B2=10, this works fine on my Excel2003, and does not work on the Excel98 machine. Anyone ever run in to this....the formula is definetly right! Confused, Mike *** Sent via Developersdex http://www.developersdex.com *** |
Excel 98 not functioning properly on formula
Can I suggest that the format of the number is not correct? Your formul is fine, so I would have to put it down to the number itself -- swedish ma ----------------------------------------------------------------------- swedish max's Profile: http://www.excelforum.com/member.php...fo&userid=2440 View this thread: http://www.excelforum.com/showthread.php?threadid=38649 |
Excel 98 not functioning properly on formula
It's not a text string and isn't a format problem either. Here is the kicker....if I manually go into the formula bar and click enter...(Recalculating the formula)....the formula then WORKS! Again, this macro and the formula within the macro works fine on my computer, it is failing on another computer I installed it on. Any ideas?! *** Sent via Developersdex http://www.developersdex.com *** |
Excel 98 not functioning properly on formula
May I say you haven't provided all the information. What is this about a
macro? What is in a worksheet formula and what is in a macro and how is the macro activated? What are the input values, how did you prove it is not a string and not a formatting problem, what results did you expect and why and what did you get instead? -- Kind regards, Niek Otten Microsoft MVP - Excel "Michael Smith" wrote in message ... It's not a text string and isn't a format problem either. Here is the kicker....if I manually go into the formula bar and click enter...(Recalculating the formula)....the formula then WORKS! Again, this macro and the formula within the macro works fine on my computer, it is failing on another computer I installed it on. Any ideas?! *** Sent via Developersdex http://www.developersdex.com *** |
Excel 98 not functioning properly on formula
Michael Smith -
Ok this is strange, I export my beautiful clean sub to a 98 machine and when it calculates a basic if statement, it does not caluculate properly. Example, =IF(B2=10,"GOOD","BAD") On the 98 machine it returns BAD even if B2=10, this works fine on my Excel2003, and does not work on the Excel98 machine. Anyone ever run in to this....the formula is definetly right! Maybe cell B2 contains a formula or computed value that is not exactly 10. If so, try something like: =IF(ABS(B2-10)<0.000001,"GOOD","BAD") - Mike www.mikemiddleton.com |
Excel 98 not functioning properly on formula
Have calculation set to Automatic?
-- Regards, Tom Ogilvy "Michael Smith" wrote in message ... It's not a text string and isn't a format problem either. Here is the kicker....if I manually go into the formula bar and click enter...(Recalculating the formula)....the formula then WORKS! Again, this macro and the formula within the macro works fine on my computer, it is failing on another computer I installed it on. Any ideas?! *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 05:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com