ExcelBanter - Excel Formula

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formula (https://www.excelbanter.com/excel-worksheet-functions/115915-excel-formula.html)

Pat

Excel Formula

If the cell on which a formula is based is 0 or empty, I want the result that
is shown to be blank. How do I build that into the formula?

Pete_UK

Excel Formula

=IF(A1=0,"",A1)

Hope this helps.

Pete

Pat wrote:
If the cell on which a formula is based is 0 or empty, I want the result that
is shown to be blank. How do I build that into the formula?

Pat

Excel Formula

That almost does the trick. Here is the formula I am working with:

=(c4-b4)+1

If there is nothing in b4, how do I make the "if" statement work?

"Pete_UK" wrote:

=IF(A1=0,"",A1)

Hope this helps.

Pete

Pat wrote:
If the cell on which a formula is based is 0 or empty, I want the result that
is shown to be blank. How do I build that into the formula?

Teethless mama

Excel Formula

=IF(OR(B4="",B4=0),"",C4-B4+1)

"Pat" wrote:

If the cell on which a formula is based is 0 or empty, I want the result that
is shown to be blank. How do I build that into the formula?

All times are GMT +1. The time now is 08:31 PM.