Specific Formula

[Rory G. Stewart]

I am trying to calculate the amount in money of the
quantity left at the end of a particular job, please see
below:

Column A - Quantity required = 100
Column B - Cost of quantity required each = £1.00
Column C - Total cost of column b multiplied by column A =
£100.00
Column D - Minimum Order Quantity = 101
Column E - Amount in £ left after quantity required is used
= (D - A) x B = £1.00 Question is how can you formulise
column E so that if there is no cost left show this cell
empty without any sum / numbers but still have the formula
in the back ground. If this was QuatTro Pro then the
formula would read:

@sum(E"","",D-A*B)

Please also advise if you are calculating a total number
from say column a through to e how to insert text without
causing an error in the total.

Regards
Rory.

 

[J.E. McGimpsey]

One way:

E1: =IF(D1=A1,"",(D1-A1)*B1)