• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to give 0 if no value in corresponding cell

Hello

please find attached file. I have a cell which has a date formula. Now i need to adjust this formula in such a way that this cell will display no date if there is no value in corresponding cell

Please help
 

Attachments

  • Formula to give 0 if no value in corresponding cell.xlsx
    107.5 KB · Views: 0
Hi,
I think you just need an IF statement:
=IF(B2<=0,0,DAY(DATE(YEAR(J$1),MONTH(J$1)+1,)))

Regards,

Edit:
Nebu you always there :)
 
And in case if you don't want to change your current formulas, you show "0" with the help of conditional formatting:

1) Select your range J2:O10
2) Conditional formatting
3) Formula
=B2=0

4) Format > Custom > "0"
5) ok

Note: it will only for display and will not change the values to zero.

Regards,
 
Back
Top