← Back to Kurakani

For mula

Original Post

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
2 Replies
HelpYouHelpMe Jul 30, 2021 4:54 PM
Logan, copy the following formula from cell B7 to the cells in column B: =IF(ISBLANK(A7),"0",A7)
Logan Aug 2, 2021 8:51 AM
Thank you,
Login to join the conversation.

You might be interested in...

Latest Kurakani View all
Page 1 of 29
Recent Classifieds View all
Page 1 of 33
Upcoming Events View all
Page 1 of 2
Service Providers View all
Page 1 of 23
Ask Sajha AI Assistant