I am expecting that NOW() will update every time any cell recalculates. I do not know how recalculation is controlled.
I have come across this before and ended up referencing a fixed time in cell (pasted from NOW()) steve On 31/10/2019 09:02, pete wrote: > 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
