How to format a conditional cell

[sahm4mk]

I am a fairly 'basic' user and need to figure out how to calculate interest on a cell - but only if it is more than 1 day late.

How do I calculate a conditional cell using a formula? (example: If sum(A14-A12) is >1 then multiply A16 x*.000110 * sum(A14-A12)??)
A16 being the Amount Due
A14 being the Date Paid
A12 being the Date Due

[Special-K]

You didnt say whats to happen if A14 - A12 NOT > 1 so...

=IF(A14-A12 > 1,A16*0.00011*(A14-A12),"A14-A12 is NOT > 1")

[dilipandey]

Hi Sahm4mk,


Welcome to the forum.

Use the following formula:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>