How is this happening?C = A-BD=IF(C1=0,3,"OK","KO")How to fix that?

jop25 One way with the above sample:=IF(ROUND(C1,1) = 0,3, "OK", "KO")

jop25 As Lorenzo explained that's floating point error. Floating-point arithmetic may give inaccurate result in Excel - Office | Microsoft Docs Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” | Microsoft 365 Blog There is no other solution but round.

jop25 There are moments when you stand on the hose. Sorry, but was totally on the wrong track. As Mr. Baklan and Tz have already informed, this is only possible with rounds in the IF function. Here now the example map with the formula: = IF (ROUNDDOWN (A1-B1; 1); "OK"; "KO") Thank you for your patience and time. NikolinoI know I don't know anything (Socrates)

Thanks.I tried that before, but thought it would be something wrong with my excel settings or formatting.That it wouldn't be needed the round function.

jop25 Please have a look at formatting your cells. The cells are probably formatted as user-defined. Format numbersThat would have to be like in the inserted file.=IF(C1=0.3,"OK","KO")You want an "OK" with 0.3. But your calculation (B1-A1) can only result in (minus) -0.3,so "KO" should appear everywhere on D. I would be happy to know if I could help. NikolinoI know I don't know anything (Socrates) * Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

if different results | Microsoft Community Hub

12 Replies

NikolinoDE
Platinum Contributor
Jul 23, 2021
jop25
Please have a look at formatting your cells.
The cells are probably formatted as user-defined.
Format numbers
That would have to be like in the inserted file.
=IF(C1=0.3,"OK","KO")
You want an "OK" with 0.3.
But your calculation (B1-A1) can only result in (minus) -0.3,
so "KO" should appear everywhere on D.

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

IF_minus.xlsx8 KB
- jop25
  Copper Contributor
  Jul 23, 2021
  Sorry i edited my post. It is C=A-B
  - NikolinoDE
    Platinum Contributor
    Jul 23, 2021
    Take a look at my previous message and go into cell formatting.
    Or look at the inserted file, there is no problem,
    could use this file or insert cells into your existing one.
    Nothing changes in the formula, you can of course also use the ROUND function of L z.
    
    Thank you for your patience and time.
    
    Nikolino
    I know I don't know anything (Socrates)
    
    Hope I was able to help you and would be happy to know if I could help you.
Lorenzo
Silver Contributor
Jul 23, 2021
jop25

One way with the above sample:
=IF(ROUND(C1,1) = 0,3, "OK", "KO")
- jop25
  Copper Contributor
  Jul 23, 2021
  Thanks.
  I tried that before, but thought it would be something wrong with my excel settings or formatting.
  That it wouldn't be needed the round function.

Forum Discussion

if different results

12 Replies

Resources