I’ve been using Calc since it was first released and occasionally I discover an older spreadsheet with some clever formulas that I know would take a bit of effort to re-create. So I’ll add them to this post as I encounter them.
- Show elapsed time to right now as years and months
Formula: =TEXT(YEARS($A2,NOW(),0),0)&” Years “&TEXT(MONTHS($A2,NOW(),1)-(YEARS($A2,NOW(),0)*12),0)&” Months”
Sample Result: 5 Years 3 Months - Find the minimum value of a range excluding values below a specific limit
Formula: =MINIFS(I3:I310,H3:H310,”>4″)
This returns the minimum value present in the first range if the value in the same row of the second range is > four.