logan
Replies to this thread:

More by logan
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 For mula
[VIEWED 1611 TIMES]
SAVE! for ease of future access.
Posted on 07-29-21 2:38 PM     Reply [Subscribe]
Login in to Rate this Post:     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

 
Posted on 07-30-21 4:54 PM     [Snapshot: 155]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Logan, copy the following formula from cell B7 to the cells in column B: =IF(ISBLANK(A7),"0",A7)


 
Posted on 08-02-21 8:51 AM     [Snapshot: 350]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 90 days
Recommended Popular Threads Controvertial Threads
सालीको चाक
ChatSansar.com Naya Nepal Chat
साझाका लेखाईले आतंकित बनाउछ
How's brain of Republican wired? School Shootings Data
Kathmandu- the capital of political ideas?
Where do most Nepali live in Albany, NY
TPS Holder with travel document
##केटा हो ,*Monthly* कती *SAVE* हुन्छ ? ##
Abortion should be illegal in US
is Rato Bangala school cheating?
Balen Shah and the hype
Marriage certificate error
Democrat wants to run election like in India. Chaos and Confusing to voters.
Bibeksheel Sajha Party and Balen Shah
त्रुम्पधारीको कुतर्क
Nepali students flooding Australia
Wife hates Travel Nurse/s
के नेपाल टाट पल्टी सकेको हो ?
TPS Nepal travel on Advance Parole
Saroj Sai - Cover Songs - Music
is Rato Bangala school cheating?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters