Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
greetings
The formula shown is in B5, dragged down to B10. It refers to values in A5:A10. Could someone explain in ordinary English how I should interpret what it is doing: I'm particularly unsure how to interpret: a) why the criteria for the Countif is itself a range. What does that mean? b) when does the logical test of the If statement return TRUE? {=If(A5<A$5:A$10, 1/Countif(A$5:A$10, A$5:A$10))} Sample output A B A B 4 FALSE 3 FALSE 0 1 0 0.333333 3 1 3 FALSE 1 0.333333 8 FALSE 8 FALSE 3 1 3 FALSE confused anny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expression for Macro - help | Excel Discussion (Misc queries) | |||
Excel expression {=SUm(if(istext(c8:k8),1,0))} | Excel Worksheet Functions | |||
Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
R² expression for trendline in chart | Charts and Charting in Excel | |||
Excel Expression | Excel Discussion (Misc queries) |