Formula Help

sdmccabe · May 22, 2006

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?

CLR · May 22, 2006

=IF(A1=0,B1+C1,"A1 IS NOT ZERO")

Vaya con Dios,
Chuck, CABGx3

Peo Sjoblom · May 22, 2006

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

Regards,

Peo Sjoblom

sdmccabe · May 23, 2006

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

Formula Help

sdmccabe

CLR

Peo Sjoblom

sdmccabe