BIG PROBLEM

W

Wu

There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if anyone
of A2 or B2 is no data, or both of them are no data, C2 will show #value!

How can it does not show #value! even there are no data at A2 and B2.
 
A

Allen Browne

If this is in Excel, you might like to post in that group.
(This one is for Microsoft Access.)
 

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

Similar Threads

Query Help please 4
LOOKUP function different? 2
cell format update problem 3
Data Validation and drop-down list using IF, AND and what else? 8
copy and paste the cell with formula ="1" 3
Adding values in to table for appropriate fields only 5
calculate total hours/minutes from two time cells 7
Excel custom format q 3

Top