Hiding Formulas

  • Thread starter Thread starter jdy
  • Start date Start date
J

jdy

I have a total column of a quote form that multiplies the
quantity column X the unit price column. It works fine
except that each of the total column rows says that are
blank say "#value" in each of them. I would like for the
total column to be blank except for the rows that have
product entries in them. Thanks for the help in advance.
 
I'm surprised because it's supposed to write "0" but whatever:

try to use a function like isempty() it should be enought
(with or without code...)


PS/ the newsgroup .programming wasn't supposed to be about VBA ?
 
Assuming quantity is in column A and unit price in column B, one way:

C1: =IF(COUNT(B1:C1)<2,"",B1*C1)
 
You must log in or register to reply here.

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

Excel Subtracting multiple columns from another column 3
Macro Runs when the user changes any cell on the work sheet 4
Share Portfolio - Averaging the Cost per Shareholding 1
Help needed 0
Problem with a loop and column references 27
Help with loop-I'm stuck 7
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Quantities per week?? 1

Back
Top