Formula Help
Try this:
=IF(D22=TRUE,NOW(),"")
However, NOW will return the system time and will continue to change,
so I'm not really sure what the purpose of the formula is.
Hope this helps.
Pete
On Oct 25, 1:13 am, Randy wrote:
Anyone know how to modify this formula so it does not round anymore?
=IF(D22=TRUE, CEILING(MOD(NOW(),1),TIME(,5,)),"")
--
Randy Street
Rancho Cucamonga, CA
|