Great, thanks. I think I should have said the value of the first cell is
actually 00/00/0000 as a cell formated as a date field, and no date is
provided.

"Peo Sjoblom" wrote:

=IF(A1=0,B1*2,"")


Regards,


Peo Sjoblom


"sdmccabe" wrote:

Could you suggest a formula to look at the value of one cell and, if the
value of that cell is zero, look at the value of another cell and make a
calculation?