Can system time & date be nested in conditional formula?

[Masif]

I need to nest the computer's system date & time in a cell with condition if
the figure in a referance cell is less than some amount i.e. 1,000 then the
destination cell should show current date & time otherwise it doesn't need.

 

[Bernard Liengme]

=IF(A1<1000,NOW(),"")
will display the date/time if A1 is less than 1000
However you may see a number like 39869.624 since we need to format the cell
Do this in one of two ways
1) select cell, open Format dialog using CTRL+1 and enter custom format such
a mm/dd/yyyy hh:mm
or
2) in a blank cell type =NOW() and use the Format Painter (icon like paint
brush) to 'paint' its format to your cell. Now delete the cell with =NOW()

best wishes