|
|
![]() |
#1 |
Bob's great grandson
![]() |
![]()
You can set aside a cell and put in 1.5 in that cell. For example we use cell X1 and have 1.5 in there. You can edit Peter's formula =IF((ABS(B1-A1)>X1), "FALSE", "TRUE"). To make adjustments, you can quickly change X1 to 1 or .5 and all the formulas pointing to it will adjust accordingly.
|
![]() |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|