MrExcel Publishing
Your One Stop for Excel Tips & Solutions

counting pieces, "+2"

Posted by jim on January 29, 2002 11:44 AM

Hi group,

This is my formula:

=(D6*12+E6)*C6*R2/12+2 it resides in AF6

I need to always add "+2" to the count, the problem is
this formula brings the count into cell AF6, so if
D6 & E6 & C6 are empty the "+2" still comes into AF6
and is totaled in a column count.

This is what i'm trying to accomplish:
If C6 >1 then =(D6*12+E6)*C6*R2/12+2, else if C6 = 0
then =(D6*12+E6)*C6*R2/12

Any thoughts on how to get around this or "write it



Posted by JohnG on January 29, 2002 12:05 PM

=IF( C6 >1 ,(D6*12+E6)*C6*R2/12+2,(D6*12+E6)*C6*R2/12 )

Posted by Mark W. on January 29, 2002 12:26 PM

What's the domain of C6, D6, and E6?...

Can these cells legitimately contain negative or
zero values?

Posted by jim on January 29, 2002 1:14 PM