ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/89885-formula-help.html)

sdmccabe

Formula Help

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

Formula Help

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

Vaya con Dios,
Chuck, CABGx3

"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?

Peo Sjoblom

Formula Help

=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?

sdmccabe

Formula Help

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.

"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?

All times are GMT +1. The time now is 04:29 PM.