Excel 2013 formula query

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?

February 11th, 2014 5:23am

You could use

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

Free Windows Admin Tool Kit Click here and download it now
February 11th, 2014 5:53am

Once again Hans you have come to my rescue - many thanks. That formula has worked a treat!
February 11th, 2014 6:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics