ExcelBanter - Entering multiple formulas in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Entering multiple formulas in one cell (https://www.excelbanter.com/excel-worksheet-functions/24879-entering-multiple-formulas-one-cell.html)

Entering multiple formulas in one cell

How do I add the round down function to the formula below?
IF((OR(B3="",B4="")),0,IF((B4<B3),((B4-B3)*24)+24,(B4-B30)*24))

Bob Phillips

Down to the integer

=ROUNDDOWN(IF(OR(B3="",B4=""),0,IF(B4<B3,(B4-B3)*24+24,(B4-B30)*24)),0)

--
HTH

Bob Phillips

"HP" wrote in message
...
How do I add the round down function to the formula below?
IF((OR(B3="",B4="")),0,IF((B4<B3),((B4-B3)*24)+24,(B4-B30)*24))

All times are GMT +1. The time now is 09:00 AM.