SOLVED

IF function value_if_false as a cell

Copper Contributor

I'm trying to create a formula where if the end time is later than 4pm the split time is 4pm, but if it is earlier than 4pm the split time is the end time.  However it just shows up as =C6 instead of the actual time entry in the cell C6.

 

=IF(C6="","",IF(C6>(--"4:00 PM"),"4:00 PM","=C6"))

NatARG_1-1649797142610.png

 

Any help is appreciated

2 Replies
best response confirmed by NatARG (Copper Contributor)
Solution

@NatARG 

=IF(C5="","",IF(C5>$D$1,$D$1,C5))

You can try this formula in the attached file. It seems to work in my sheet if i correctly understand what you want to do. You can dynamically enter the split time in cell D1. 

Thank you! Worked perfectly.
1 best response

Accepted Solutions
best response confirmed by NatARG (Copper Contributor)
Solution

@NatARG 

=IF(C5="","",IF(C5>$D$1,$D$1,C5))

You can try this formula in the attached file. It seems to work in my sheet if i correctly understand what you want to do. You can dynamically enter the split time in cell D1. 

View solution in original post