Using Invoice template: overriding formulae

[Guest]

I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.

My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?

WTIA

Andrew Stucken

 

[Guest]

Don'y know how to override the original protectiion. Easiest would be to copy
and paste into new sheet and use this to create your own template.

Roger

 

[Gord Dibben]

Andrew

First you must unprotect the sheet.

Tools>Protection>Unprotect sheet.

Then you must select cells in the Qty column and Data>Data Validation>Clear
All>OK

Same for the Total column.

Then in the top cell of the cyan shaded area under "Total" enter this formula

=IF(ISNUMBER(D18),D18*K18,0)

Drag/copy down to cell above Subtotal.

When happy, find INVOICE.XLT on your computer and change its name to
INVOICE.OLD in case you screw up building the new version.

File>Save as>Type>Template(*.xlt) the altered workbook with the name of
INVOICE.XLT


Gord Dibben Excel MVP