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

Sandy

Replace@mailinator with @tiscali.co.uk


"carl" wrote in message
...
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.

One option:

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

HTH
--
Dana DeLouis
Win XP & Office 2003


"carl" wrote in message
...
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.

On Mon, 19 Sep 2005 11:06:01 -0700, "carl"
wrote:

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
__________________________