software

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?

=IF(A1=0,B1 C1,quot;A1 IS NOT ZEROquot;)

Vaya con Dios,
Chuck, CABGx3

quot;sdmccabequot; wrote:

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

=IF(A1=0,B1*2,quot;quot;)Regards,Peo Sjoblomquot;sdmccabequot; wrote:

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

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.

quot;Peo Sjoblomquot; wrote:

gt; =IF(A1=0,B1*2,quot;quot;)
gt;
gt;
gt; Regards,
gt;
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;sdmccabequot; wrote:
gt;
gt; gt; Could you suggest a formula to look at the value of one cell and, if the
gt; gt; value of that cell is zero, look at the value of another cell and make a
gt; gt; calculation?