If/Then Forumla to create blank cell???

[gmh]

I have a basic order form spreadsheet. There is a formula in cell G2
that calculates the purchase amount (quantity x Unit Price o
specifically =A22*F22).

I need to copy it into the appropriate cells for items that aren'
listed in row 22.

It would, of course, be easy to just copy the formula down column G
but then the Rows without an item in them would produce a $0.00 and
do not want that $0.00 to show up. I only want it to show up if ther
is a value greater than $0.00 in the cell.

Can you write an IF THEN statement that puts blanks in the G Colum
Cells that have no items in them, and print the amount in the rows tha
do have items in them. If its not an If Then statemtn - then how do
make this occur??

I attached a jpeg of the area i am trying to work w/

tHANKS!

+-------------------------------------------------------------------
|Filename: excelformulag22.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4686
+-------------------------------------------------------------------

 

[William Horton]

=IF(ISBLANK(A22),"",A22*F22)

The above formula will work.

Bill Horton

 

[MartinW]

Alternatively you can suppress zero values.

To do this go to:
Tools>Options>View tab and uncheck "zero values"

HTH
Martin

 

[MartinW]

Some might say sneaky!! Some might even say cheating!!
Me, I say BRILLIANT!!

 

[Arvi Laanemets]

Hi

Some might say sneaky!! Some might even say cheating!!
Me, I say BRILLIANT!!

But, when p.e. you calculate average from this range, such 'hidden' 0's are
taken fully into account (the same for unchecking zero values).


Arvi Laanemets