Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Does -- Mean In A Formula
I have a formula that looks as follows:
=IF(AND(H24="NEX",$C24="Operations",U$15="Yes"),SU MPRODUCT(--($D$17:$D$228=D24),--($H$17:$H$228="EX"),$T$17:$T$228)/SUMPRODUCT(--($D$17:$D$225=D24),--($H$17:$H$225="NEX")),"") What is the prupose of the -- in the formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |