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, `#VALUE!`

.

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 `0`

.

Excel complains when I try and enter the formula `=IF(ISNUMBER(E1), E1 * D1, 0)`

. Why does it do so?

`E1*D1`

and since most of cells are empty in`Column D`

then Excel must return`0`

instead of`#Value`

error and if you want to replace`0`

with`blank`

the use`IF`

!! – Rajesh Sinha Sep 25 '19 at 9:40`0`

instead of`#VALUE!`

. Replacing a`0`

with blank is trivial and after the fact. – ProfK Sep 25 '19 at 10:31