ABS
ABS(number)
The value without its sign, such as how far a task has moved from its baseline in either direction. It takes a duration as well as a number, and a duration stays a duration: ABS of -3 days of float is 3 days.
Arguments
| Argument | What to give it |
|---|---|
| number | A number or a duration. A blank gives a blank. |
Examples
Formula=ABS(WORKDAYS(IN(BASELINE(), [Finish date]), [Finish date]))
How far the task's finish is from its baseline finish, early or late, in working time.
Formula on relationships=ABS([Lag])
On a relationship: the size of its lag or lead.
Formula on WBS rows=ABS(MIN(Tasks[Total float]))
On a WBS row: the size of the lowest float under the node.
Reach for something else when
| You want | Use |
|---|---|
| Only the late side, with early as 0 | MAX(0d, …): see MAX |
| To keep a value inside a range | CLAMP |
Common questions
What does "ABS needs a number or duration" mean?
A date or text has no sign. For the time between two dates, take ABS of WORKDAYS or CALDAYS.