Modifying a Formula / OR Question

[Guest]

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]

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

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Dana DeLouis]

One option:

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

HTH

 

[Richard Buttrey]

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
__________________________