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

I need to copy it into the appropriate cells for items that aren't
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 I
do not want that $0.00 to show up. I only want it to show up if there
is a value greater than $0.00 in the cell.

Can you write an IF THEN statement that puts blanks in the G Column
Cells that have no items in them, and print the amount in the rows that
do have items in them. If its not an If Then statemtn - then how do i
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 |
+-------------------------------------------------------------------+

--
gmh
------------------------------------------------------------------------
gmh's Profile: http://www.excelforum.com/member.php...o&userid=33792
View this thread: http://www.excelforum.com/showthread...hreadid=535610