Sum IF function From time to number not working??
I'm amazed. But you didn't reply to the bit where we asked:
" ... (and what numbers in the input cells)? "
so those of us without ESP can't investigate your problem.
--
David Biddulph
wrote in message
...
On 17 Dec, 11:42, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
What formulae were you using for your ROUNDUP and ROUND solutions (and
what
numbers in the input cells)?
--
David Biddulph
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- Hide quoted text -
- Show quoted text -
Hi,
I am using this formula
=IF(G5="",0,ROUND((G7-G5-G6)*24,0))
That rounds it to 0.999998
and if I do not round it the value is 0.4999998
Thanks
|