|
| Calc has ifs and xlookup. I have used ifs (think it was averageifs) for sure and think I used xlookup for something. xlookup is listed under addins not spreadsheet which I think would make more sense.
https://wiki.documentfoundation.org/Documentation/Calc_Functions/Lis...
SUMIFS Mathematical functions
AVERAGEIFS Statistical analysis functions
COUNTIFS Statistical analysis functions
MAXIFS Statistical analysis functions
MINIFS Statistical analysis functions
IFS Logical functions
Formulas added in version 24.8
https://wiki.documentfoundation.org/ReleaseNotes/24.8
• FILTER function was added. (Balázs Varga, allotropia) tdf#126573 OASIS OFFICE-4156
• LET function was added. (Balázs Varga, allotropia) tdf#137543
• RANDARRAY function was added. (Balázs Varga, allotropia) tdf#126573
• SEQUENCE function was added. (Balázs Varga, allotropia) tdf#126573
• SORT function was added. (Balázs Varga, allotropia) tdf#126573 OASIS OFFICE-4157
• SORTBY function was added. (Balázs Varga, allotropia) tdf#126573 OASIS OFFICE-4158
• UNIQUE function was added. (Balázs Varga, allotropia) tdf#126573
• XLOOKUP function was added. (Winfried Donkers) (Balázs Varga, allotropia) tdf#127293 OASIS OFFICE-4154
• XMATCH function was added. (Balázs Varga, allotropia) tdf#128425 OASIS OFFICE-4155
Most recent formulas added in 25.8
https://wiki.documentfoundation.org/ReleaseNotes/25.8
• CHOOSECOLS function was added. (Xisco Faulí, TDF) tdf#151000
• CHOOSEROWS function was added. (Xisco Faulí, TDF) tdf#150999
• DROP function was added. (Xisco Faulí, TDF) tdf#150998
• EXPAND function was added. (Xisco Faulí, TDF) tdf#151001
• HSTACK function was added. (Xisco Faulí, TDF) tdf#150868
• TAKE function was added. (Xisco Faulí, TDF) tdf#150997
• TEXTAFTER function was added. (Xisco Faulí, TDF) tdf#150865
• TEXTBEFORE function was added. (Xisco Faulí, TDF) tdf#150864
• TEXTSPLIT function was added. (Xisco Faulí, TDF) tdf#150866
• TOCOL function was added. (Xisco Faulí, TDF) tdf#150879
• TOROW function was added. (Xisco Faulí, TDF) tdf#150878
• VSTACK function was added. (Xisco Faulí, TDF) tdf#150867
• WRAPCOLS function was added. (Xisco Faulí, TDF) tdf#150881
• WRAPROWS function was added. (Xisco Faulí, TDF) tdf#150880 | |
|
Microsoft Office options?
