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,
copy the following formula from cell B7 to the cells in column B:
=IF(ISBLANK(A7),"0",A7)
Please log in to reply to this post
You can also log in using your Facebook
What people are reading
You might like these other discussions...
· Posts 9
· Viewed 12056
· Likes 1
· Posts 7
· Viewed 3515
· Likes 1
· Posts 21
· Viewed 9089
· Likes 1
· Posts 5
· Viewed 7379
· Likes 1