Charting

D

Droid

I am trying to develop a chart that can be used as an
order form where the spreadsheet will POTENTIALLY
add "item a" item b" and "item c" to deliver a total. For
example:

4 pens @ 1.00 = 4.00
3 clips @ 50c = 1.50
6 pencils @ 40c = 2.40
TOTAL = 7.90

I've completed the chart to do this, but can not make #s
add and total unless all items are included. For example,
if I leave out the Clips it will read:

4 pens @ 1.00 = 4.00
!VALUE
6 pencils @ 40c = 2.40
TOTAL =

Question - how can I make this work if I do not have to
include all items on EVERY order?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top