When I copy a cell that is formatted for Date has date it will copy that date. If blank instead of 0 it gives 1/0/1900. Is there any formula that will give me 0 when to be copied cell is blank and if there is value copies the value. Last edited: 29-Jul-21 03:56 PM
Logan · Jul 29, 2021 2:38 PM · 10,812 views
Logan, copy the following formula from cell B7 to the cells in column B: =IF(ISBLANK(A7),"0",A7)
HelpYouHelpMe · Jul 30, 2021 4:54 PM
Thank you,
Logan · Aug 2, 2021 8:51 AM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion