Re: Excel (1458312) | |||
Home > SubChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Re: Excel |
|
Posted by Bill West on Thu Dec 14 23:16:05 2017, in response to Re: Excel, posted by BusRider on Thu Dec 14 22:11:10 2017. Yes, either as part of the IF's test or as part of the action it is to take.=IF(CEILING(B1,"0:15")>11/24,CEILING(B1,"0:15")+"2:00",CEILING(B1,"0:15")) Bill |