• 506K Members
• 5,038 Online
• 603K Conversations
SOLVED

Highlighted
New Contributor

# BUG ON FUNCTION IF ?

Hi, I have an issue on Excel, I think is a Bug. So follow this simple test:

Always Format Hour for All cell

1) Into Cell B4 put 08:00:00

2) Into Cell C4 put 12:00:00

3) Into Cell F4 put formula =IF(SUM((C4-B4) + (E4-D4))=0;"";SUM((C4-B4) + (E4-D4)))  -> ( Result 04:00:00 )

4) Into Cell G4 put 04:00:00

Now.... Into Cell H4,

if you put G4-F4 -> ( Result 00:00:00 )

BUT if you put  =IF(F4="";"";G4-F4) I give an error -> ( Result ################### )

Why ??? It's a bug ???

Thanks !

4 Replies
Solution

# Re: BUG ON FUNCTION IF ?

That's a floating point error.

Try:

`=IF(F4="";"";G4-F4+4-4)`

# Re: BUG ON FUNCTION IF ?

@Detlef Lewin , so many floating point error examples here and they are coming. It looks like hot topic.

# Re: BUG ON FUNCTION IF ?

Great !!! Many many thanks ... it's work !!! Thanks for your reply, have a good day Sir.

# Re: BUG ON FUNCTION IF ?

Many many thanks ... I tryed @Detlef Lewin. Have a good day Sir.
Related Conversations
[FIXED] Bug while trying to close tabs
HotCakeX in Discussions on
24 Replies
Interop Teams Skype
Lukas Babinger in Microsoft Teams on
7 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies