Can system time & date be nested in conditional formula?
 

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.

Can system time & date be nested in conditional formula?
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Masif" wrote in message
...
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.