Entering multiple formulas in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
Down to the integer

=ROUNDDOWN(IF(OR(B3="",B4=""),0,IF(B4<B3,(B4-B3)*24+24,(B4-B30)*24)),0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula error 1
Timesheet formula problem 2
Formula for adding time 2
weight loss 3
Problem with VLOOKUP 4
Can a cell be turned on or off? 1
SORT data containing formula 5
dividng numbers using the sumif function 2

Back
Top