This repository was archived by the owner on Oct 26, 2021. It is now read-only.
Standard Deviation #6
WayneLambert
announced in
Excel Guides
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Formula shows the standard deviation within the [NumericFieldForTable] data range based upon the conditions of the 3 dimensions being met.
{=STDEVA(IF(IF(SelectedUBR="-- (All)",TRUE,tblData[UBR Selection]=SelectedUBR), IF(IF(SelectedCountry="-- (All)",TRUE,tblData[Host Country]=SelectedCountry), IF(IF(SelectedCity="-- (All)",TRUE,tblData[Host City]=SelectedCity), IF(IF(TRUE=TRUE,tblData[CT]=SelectedCorporateTitle), tblData[NumericFieldForTable]))))}Beta Was this translation helpful? Give feedback.
All reactions