Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Bob, Excellent, I can't thank you enough for this information!!!
Bob Phillips wrote: Hi Debbie, The curly brackets are used to contain an array of constant values, so the COUNTIF works on the array, that is both 3.028 and 4.04, rather than a single value -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) Bob - Thank you soooo much. This works fabulously! I just have one more question if you have time to answer. What do the { } brackets indicate as [quoted text clipped - 22 lines] percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you can offer. -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if statements, and statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
"IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |