Formula Help
 

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

Formula Help
 

One way:

=IF(D22,NOW(),"")

In article ,
Randy wrote:

Anyone know how to modify this formula so it does not round anymore?

=IF(D22=TRUE, CEILING(MOD(NOW(),1),TIME(,5,)),"")

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

Formula Help
 

Never mind....i figured it out...

=IF(D22=TRUE, MOD(NOW(),1),"")

Thanks anyway...

--
Randy Street
Rancho Cucamonga, CA


"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

Formula Help
 

Try this:

=IF(D22=TRUE,MOD(NOW(),1),"")

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