SOLVED

Rounding Calculated Numbers

Occasional Visitor

I have two fields at are date fields.  I want to subtract the time it takes to complete the task (Date Authorized - Date Requested).  I need it to do two things, 

 

1.  If the number comes up 0.1:  I need this to always round up to 1, not zero.

 

2.  If the number comes up 1.1:  I need this to round up to 2.0

 

I've looked at the roundup function but can't get it to always be a minimum of 1.

1 Reply
best response confirmed by VABRD (Occasional Visitor)
Solution

@VABRD How about

 

=MAX(ROUNDUP(DateAuthorized-DateRequested,0),1)