SOLVED

Rounding Calculated Numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2251488%22%20slang%3D%22en-US%22%3ERounding%20Calculated%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2251488%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20fields%20at%20are%20date%20fields.%26nbsp%3B%20I%20want%20to%20subtract%20the%20time%20it%20takes%20to%20complete%20the%20task%20(Date%20Authorized%20-%20Date%20Requested).%26nbsp%3B%20I%20need%20it%20to%20do%20two%20things%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20If%20the%20number%20comes%20up%200.1%3A%26nbsp%3B%20I%20need%20this%20to%20always%20round%20up%20to%201%2C%20not%20zero.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20If%20the%20number%20comes%20up%201.1%3A%26nbsp%3B%20I%20need%20this%20to%20round%20up%20to%202.0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20looked%20at%20the%20roundup%20function%20but%20can't%20get%20it%20to%20always%20be%20a%20minimum%20of%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2251488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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 (Visitor)
Solution

@VABRD How about

 

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