Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 03-13-2019, 12:18 PM
anne.kiss@ntlworld.com anne.kiss@ntlworld.com is offline excel macro returning the wrong value Windows 10 excel macro returning the wrong value Office 2013
Novice
excel macro returning the wrong value
 
Join Date: Mar 2019
Posts: 2
anne.kiss@ntlworld.com is on a distinguished road
Default

Many thanks for these replies. The two values were calculated, not input manually.

Yes you are correct I added a poll by mistake - this was my first attempt at a post, so got it wrong.

When I went into this forum today my post was under excel programming, so maybe the website changes things for you?

Is there any way of getting round the floating point arithmetic? I only have one digit after the decimal point so I could split the number into two cells and do two calculations and then put the numbers back together again. This would be very messy, so if anyone knows how to make sure the floating point arithmetic is correct, please let me know.
Reply With Quote
 

Tags
cell value, excel macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel macro returning the wrong value Table column width wrong - unless macro paused!? Kebap Word VBA 7 09-21-2018 03:14 PM
Returning text, date, time, location from one Excel sheet to another dave57 Excel 17 06-15-2017 10:45 AM
excel macro returning the wrong value Excel colums are wrong way around SteveL Excel 1 05-06-2015 02:09 AM
excel macro returning the wrong value Macro operates on wrong document window marceepoo Word VBA 1 12-20-2012 03:12 PM
need macro for quiz (?) repeat of wrong answers with shuffle braveshark PowerPoint 0 10-02-2012 06:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft