Sum IF function From time to number not working??
What formula are you using for ROUND in each case? 0.9999998 doesn't look
awfully rounded to me!
wrote in message
...
Hi,
I am having a very large problem that may have the simplest solution!
Wondering if anyone can help??
I have in Cell G8 the following formula:
=IF(G5="",0,(G7-G5-G6)*24)
The problem I am encountering is that it value the cell as 0.4999998
and if I ROUNUP it vlaues it at 1.0 and if i just ROUND it values it
as 0.9999998??
Is there any way of making it round correctly??
Thanks
|