Show numbers nearly the same

hendrikbez

Board Regular
Joined
Dec 13, 2013
Messages
82
Is this possible.

I have a number that can change very time eg 0.00001234
Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004, 0.00000008, 0.00000016 (goes up by double each time.

I need that if the number on top (0.00001234) is about 100 less (0.00001134) or 100 (0.00001334) more, it must show that number in a color

is this possible
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

hendrikbez

Board Regular
Joined
Dec 13, 2013
Messages
82
I have installed office 2019 pro, when I type this in

=AND(B4>=$A$2-0.00001,B4<=$A$2+0.00001)

Then it gives me a error (see screenshot)

Then I have done this

'=AND(B4>=$A$2-0.00001,B4<=$A$2+0.00001)

but is not working
 

Attachments

  • Screenshot_5.png
    Screenshot_5.png
    43.5 KB · Views: 4

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Change the decimal separators to a comma & the comma to your normal formula separator.
 

hendrikbez

Board Regular
Joined
Dec 13, 2013
Messages
82

ADVERTISEMENT

Sorry I do not understand the second part, I have change it to
'=AND(B4>=$A$2-0,00001,B4<=$A$2+0,00001)
but still not working
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
What do you normally use inside a formula to separate the arguments?
Maybe a semi-colon?
 

hendrikbez

Board Regular
Joined
Dec 13, 2013
Messages
82

ADVERTISEMENT

See post 4, you did give me info there, for help that I have ask for, it worked in 2016, but give error in 2019
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Try
=AND(B4>=$A$2-0,00001;B4<=$A$2+0,00001)
If that doesn't work, try Peter's formula in post#6
If that doesn't work, please answer my question in post#16
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,719
Messages
5,524,459
Members
409,582
Latest member
riibuildersinc

This Week's Hot Topics

Top