I have a range including a Quantity column (
D) and a Rate Column (
E). In cell
F1, I have the formula
=D3 * E3, for a sub-total of Rate * Quantity.
Most of my Rate cells are empty, causing most of column
F to just display,
I thought I'd replace my formula with
=IF(ISNUMBER(E1), E1 * D1, 0), hoping that when
E1 is empty, I get a zero for my subtotal.
However, Excel doesn't like that formula, I get a popup saying there is something wrong with my formula, e.g. syntax etc.
It seems quite OK to me, if
E1 is a number, use
E1 * D1, otherwise use
Excel complains when I try and enter the formula
=IF(ISNUMBER(E1), E1 * D1, 0). Why does it do so?