L
lawson
i was reading another post and came accross the tool Ctrl Shift Enter. What
is this?
the following formula does not work if you enter it it in a cell and simply
hit enter, but if you press Ctrl Shift Enter, Excel puts { } around the
formula, and it works. the formula does NOT work if you type the {}'s
manually.
=AVERAGE(IF(array1>0,array1)) (array1 is the name of an array of numbers)
how does one know when to use Ctrl Shift Enter?
is this?
the following formula does not work if you enter it it in a cell and simply
hit enter, but if you press Ctrl Shift Enter, Excel puts { } around the
formula, and it works. the formula does NOT work if you type the {}'s
manually.
=AVERAGE(IF(array1>0,array1)) (array1 is the name of an array of numbers)
how does one know when to use Ctrl Shift Enter?