|
|
#5
01-17-2014, 05:10 AM
|
||||
|
||||
This has to do with the way Excel treats numbers.
If you format your result with 10 or more decimals, it is not 7 but 6,99999... As you formatted with 0 decimals what you see is 7, but XL sees 6,9999 The workaround is to wrap your formula with the ROUND function ( with 0 decimals). Then all should be OK. Like Code:
=ROUND((A4-FLOOR(A4,1))*24,0) Code:
=ROUND(MOD(A4,1)*24,0)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 SUMIF results changed based on filters
|
SteveBump | Excel | 5 | 10-29-2013 07:25 AM |
| Help! 'SUMIF' Formulas | dave1372 | Excel | 2 | 09-08-2011 07:05 AM |
|
SUMIF Formula question
|
jcaswell | Excel | 3 | 05-22-2011 02:52 AM |
|
Need Help With SUMIF Formula In R1C1 Style
|
Todd | Excel | 9 | 02-27-2010 08:30 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode