Add condition to =MAX formula
 

=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
:)

Add condition to =MAX formula
 

Have you tried

=if(d4<"on board","",MAX(0,((U$1-$K4)/7))*R4-T4)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KC" wrote in message
...
=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
:)

Add condition to =MAX formula
 

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

KC wrote:
=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 :)

Add condition to =MAX formula
 

Hi,

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

Mike

"KC" wrote:

=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
:)