Status
Not open for further replies.
1 - 5 of 5 Posts

#### Marachi

· Registered
Joined
·
4 Posts
Discussion Starter · ·
When I use a simple C1=abs(A1-B1) where A1=12.5 and B1=12.47 my believe is that C1 should return the value 0.03. However when I used conditional formatting on C1 where at any value greater than 0.03 the cell would color red it did. Now when I expand the amount of decimal places to 16 C1 reads 0.0300000000000011!

How is this possible and how can I solve this?

Thanx

Marachi

#### Marachi

· Registered
Joined
·
4 Posts
Discussion Starter · ·
I accidently crosslinked the outcome of another calculation with another in the used example in my first post.

Here's my exact sheet:

6.50 - 6.47 = 0.0300000000000002
12.50 - 12.47 = 0.0299999999999994
25.00 - 24.97 = 0.0300000000000011

Marachi

#### dm01

· TSF Team, Emeritus
Joined
·
2,386 Posts
Hello Marachi, welcome to TSF.

Do you still require assistance?

#### Marachi

· Registered
Joined
·
4 Posts
Discussion Starter · ·
Hello Marachi, welcome to TSF.

Do you still require assistance?
Yes I do. Can't really figure it out.

Thanx

#### Marachi

· Registered
Joined
·
4 Posts
Discussion Starter · ·
Anyone?

1 - 5 of 5 Posts
Status
Not open for further replies.