Hi

I have this query in a cell =IF(H12>0,K12*M12,L12*M12) which works great when the cells are populated, however I want to copy this formula down my column and some rows may be blank.

For example if either cell K12 or L12 is left blank I want the cell containing the above formula to appear blank and when they are populated for the answer to appear. At the moment it is showing a VALUE error when the cells aren't populated which doesn't look great.

Any thoughts?

You could use

=IF(OR(IF(H12>0,K12,L12)="",M12=""),"",IF(H12>0,K12,L12)*M12)

Once again Hans you have come to my rescue - many thanks. That formula has worked a treat!