For mula - Sajha Mobile
SAJHA MOBILE
For mula
Posts 3 · Viewed 2822 · Go to Last Post
logan
· Snapshot 0
Like · Likedby · 0
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
HelpYouHelpMe
· Snapshot 155
Like · Liked by · 0
Logan, copy the following formula from cell B7 to the cells in column B: =IF(ISBLANK(A7),"0",A7)

logan
· Snapshot 350
Like · Liked by · 0
Thank you,
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
You might like these other discussions...
· Posts 9 · Viewed 12056 · Likes 1
· Posts 7 · Viewed 3515 · Likes 1
· Posts 1 · Viewed 958
· Posts 1 · Viewed 919
· Posts 1 · Viewed 830
· Posts 1 · Viewed 911
· Posts 1 · Viewed 902
· Posts 21 · Viewed 9089 · Likes 1
· Posts 3 · Viewed 2286
· Posts 5 · Viewed 7379 · Likes 1



Your Banner Here
Travel Partners
Travel House Nepal