Formula
 

I am trying to create the following formula:
if b2 is "no, then b6-b9, otherwise, b6-b9 but not less
than zero.

I think I have this correct until I get to the "but not
less than zero" part.

=if(b2="no",b6-b9,b6-b9 but not less than zero)

Thanks

Formula
 

One way

=IF(B2="no",B6-B9,MAX(B6-B9,0))

Scott wrote:
I am trying to create the following formula:
if b2 is "no, then b6-b9, otherwise, b6-b9 but not less
than zero.

I think I have this correct until I get to the "but not
less than zero" part.

=if(b2="no",b6-b9,b6-b9 but not less than zero)

Thanks