Excel invoice

[Guest]

Im using the invoice feature in excel. I cannot figure
out how to subtract a discount. The functions only seem
to work when adding an item and its cost. I need to
deduct and item and its cost. for example 10% off of
total price.

ie... QTy Description unit price
1 electronic widgit $1000
1 Intro. Discount 10% -$100

When I enter a minus sign in front of the number I get a
error message.

 

[Norman Harker]

Hi Carlos!

I'm assuming by feature that you are referring to the INVOICE.XLT

The problem appears to be that data validation is refusing to allow
you to enter negatives.

You can change the data validation using Data > Validation and
changing the settings.

Alternatively, you could set up a couple of new columns and allow
input of the base price and discount percent. Then you can enter a
formula for the unit price.

An alternative is to add a discount column and change the data
validation for the Total column to allow you to modify the formula in
the total column.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.