need another formula.

  • Thread starter Thread starter Auntie Annette House MO
  • Start date Start date
A

Auntie Annette House MO

I need another formula that will say that if any amount if placed into cell
K33 then it will be subtracted from L36 for a total due. Annette
 
I forgot to tell you the rest of what I need Duh! (senior Moment)The formula
will say that if any amount if placed into
cell
Click to expand...
than 0 for a total due.
 
Try this:

=(K33>0)*(L36-K33)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I forgot to tell you the rest of what I need Duh! (senior Moment)The formula
will say that if any amount if placed into
cell
Click to expand...
than 0 for a total due.
 
Thank You (((((((((0)))))))))))))
It was just what I needed. Couldn'thave done it without you.
Annette
 
This works because it is not necessary to check whether K33 is a nonzero
value. Excel will automatically assign a zero value to an empty cell.
 
Back
Top