| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,)),"") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
