Modifying a Formula / OR Question

carl · Sep 19, 2005

I am using this formula:

=IF(C29+D29<2;2;C29+D29)

I would like to modify it so that if C29=0, the formula returns 0.

Thank you in advance.

Sandy Mann · Sep 19, 2005

=IF(C29=0;0;IF(C29+D29<2;2;C29+D29))

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk

Dana DeLouis · Sep 19, 2005

One option:

=IF(C29=0,0,MAX(C29+D29,2))

HTH

Richard Buttrey · Sep 19, 2005

I am using this formula:

=IF(C29+D29<2;2;C29+D29)

I would like to modify it so that if C29=0, the formula returns 0.

Thank you in advance.

=If(C29=0,0,IF(C29+D29<2,2;C29+D29))

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________