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
correctly"
Thanks,
Jim