Add condition to =MAX formula

[KC]

=MAX(0,((U$1-$K4)/7))*R4-T4

I'm using the formula above, which I need to add a condition to, but I'm not
sure how. If cell D4 = "On Board", then I want to the formula above to
continue, if anything else is in D4, I want the cell to appear blank. Thanks

 

[Don Guillett]

Have you tried

=if(d4<>"on board","",MAX(0,((U$1-$K4)/7))*R4-T4)

 

[Mike H]

Hi,

=IF(D4="On Board",MAX(0,((U$1-$K4)/7))*R4-T4,"")

Mike