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
|