need another formula.

  • Thread starter Auntie Annette House MO
  • 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
 
A

Auntie Annette House MO

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.
 
R

RagDyeR

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.
 
A

Auntie Annette House MO

Thank You (((((((((0)))))))))))))
It was just what I needed. Couldn'thave done it without you.
Annette
 
B

Barry Ford

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.
 
Top