![]() |
|
#6
|
|||
|
|||
|
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. |
| Tags |
| cell value, excel macro |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
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 colums are wrong way around
|
SteveL | Excel | 1 | 05-06-2015 02:09 AM |
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 |