Ask Your Question
0

calculate a formula only if past a due date

asked 2020-03-23 16:28:22 +0200

dejayajay gravatar image

I have a simple subtraction formula (Col.B less Col.C equals Col.D) but I only want to see a result if we have past the due date as entered into Col.A. EG: Col.A has a due date; Col.B has the amount; Col.C has the amount paid; Col.D calculates the balance due, but only if today has past the due date in Col.A.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-03-23 16:59:07 +0200

Opaque gravatar image

updated 2020-03-24 19:34:05 +0200

Hello,

=IF(TODAY()>Col.A;Col.B-Col.C;"") into Col.D (which of course is using your meta - syntax and of course assuming that less should mean minus (subtraction)).
Examples for specific rows:

=IF(TODAY()>A2;B2-C2;"") into D2
=IF(TODAY()>A3;B3-C3;"") into D3
=IF(TODAY()>A4;B4-C4;"") into D4

... and so on

Note: You need to assure that Col.A contains real calc dates (which is integers) and not text for the formula to work.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

Comments

Thank you so much. That works beautifully. Love the LO community.

dejayajay gravatar imagedejayajay ( 2020-03-24 14:01:39 +0200 )edit

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

Opaque gravatar imageOpaque ( 2020-03-24 19:33:53 +0200 )edit

Rather than having TODAY() in each and every formula calculated, set up one cell with =TODAY() and reference that cell in the formulas using an absolute cell reference, e.g. $E$5

That way TODAY() needs to be calculated only once (and you can even simulate a different date easily).

erAck gravatar imageerAck ( 2020-03-24 21:41:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-23 16:28:22 +0200

Seen: 26 times

Last updated: Mar 24