3 ms·
One of the best ways Microsoft has made Excel formulas better is by allowing line breaks (using alt-enter) and tab/spaces alignment. So instead of seeing someth
by pseudosavant 4y ago
One of the best ways Microsoft has made Excel formulas better is by allowing line breaks (using alt-enter) and tab/spaces alignment. So instead of seeing something like this:
=IIF(foobar, pv(a1:a100), IFERROR(fv(b1:b100), 0));
You can do this using alt-enter:
=IIF(
foobar,
pv(a1:a100),
IFERROR(
fv(b1:b100),
0
)
);