Hi Folks

I am having an issue with NOW()   .

I am using    =IF(ISBLANK(A3),"", IF( ISNUMBER(B3), B3, NOW() ) )  
I have copied this by dragging the corner of the cell to 100 other cells the
problem is  when i enter data into a cell in coloum 3 the time changes in every
cell in coloum 3 and it should not it does not in another sheet that is using
exactly the same formula .

What am i doing wrong  ..

Thanks Pete .



-- 
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to