Posts Tagged ‘excel’

Lookup and reference functions (reference) – Microsoft Support

January 27, 2024

https://support.microsoft.com/en-us/office/lookup-and-reference-functions-reference-8aa21a3a-b56a-4055-8257-3ec89df2b23e

Posted in - | Leave a Comment »
Tags: , ,

LOOKUP function – Microsoft Support

January 27, 2024

https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb

Posted in - | Leave a Comment »
Tags: , ,

XMATCH function – Microsoft Support

January 27, 2024

https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312

Posted in - | Leave a Comment »
Tags: , ,

NORM.INV function – Microsoft Support

September 3, 2023

https://support.microsoft.com/en-au/office/norm-inv-function-54b30935-fee7-493c-bedb-2278a9db7e13

=NORM.INV(95%,20,3)
20 = mean
3 = SD
returns value so that 95% of other values are less

Posted in - | Leave a Comment »
Tags: ,

NORM.S.DIST function – Microsoft Support

September 3, 2023

https://support.microsoft.com/en-au/office/norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88

Posted in - | Leave a Comment »
Tags: ,