formulas, please help

  • Thread starter Thread starter dstarr
  • Start date Start date
D

dstarr

Hello,

I am new to this board and everybody is very helpful, thanks.

I am trying to do a fromula on a line.

Example:

=G2*H2+I2*G2 where j2 is my answer. It works fine but I wanted to ad
it for the whole J Column. I copied and did special paste and i
worked, except 2 things. 1. it gave me (0.00) for all the blank entrie
and 2 when I print it wants to prnt all 10 million (jk) entries becaus
of the 0.00. I want to be able to add new line once in a while, so
want the forumla to stay with that column. It is getting so frustratin
that I can't fugure it out.
Please help.

Thanks - Da
 
Hi dstarr!

One way:

=IF(COUNTA(G2:I2)=0,"",G2*H2+I2*G2 )

Or:

=IF((G2*H2+I2*G2)=0,"",G2*H2+I2*G2)

Or you can use:

Tools > Options > View
Remove check from "Zero values"

--
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.
 
I tried all 3 and when I print it still prints all 1 million. When I try
1 or 2 and do a print preview nothing happends and the program says not
responding. Maybee I am Pasting it wrong. I copy the formula you gave
me then I highlight the column and do special paste. It seems like it
works but it doesn't. When I try the 3rd idea it doesn't show the 0.00
anymore but still prints all of the 0.00. More help is much
appreciated.

Thanks - Dan
 
Hi Dan!

Lets get the copying problem sorted out first.

Take the formula:

=IF(COUNTA(G2:I2)=0,"",G2*H2+I2*G2 )

With your workbook open
Click on Outlook Express or whatever you're using to read this
Select the formula above in this post.
Right click > Copy
Left Click on the Excel icon on the taskbar
Left Click on J2
Right Click in the formula bar > Paste > Enter

Now check you have the formula in J2 and that it is working.
Point to the bottom right corner of the cell until you see the + sign
Left click and hold down on the plus sign and drag down as far as you
want to go
Let go of the button

Now check the formula is working OK.

Unless you are prepared to use VBA, you'll need to use a manual
approach to setting your print area.

Select A1
Scroll to the bottom right of your required print area
Press and hold down Shift and left click the bottom right cell
File > Print Area > Set Print Area

You should now see dashed lines that demarcate your print area.

Print in the normal way.


--
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.
 
Hi dstarr!

Thanks for the confirmation.

A faster way of copying down a cell parallel to all occupied cells on
the left or right is:

Select the cell you want to copy
Point to bottom right corner
Double click the + sign

--
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.
 
Back
Top