| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Jerry W. Lewis wrote:
=S19=S20 proves nothing. Try =(S19-S20) instead. Yep, that did the trick: it returns 7.105427357601E-15 . ROUND() should solve the problem, as has already been suggested. ROUNDing the point toals to zero decimals gave me what I needed. Thanks to all for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| Rank Formula | Excel Worksheet Functions | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| ranking an row of values | Excel Worksheet Functions | |||
Hybrid Mode
