Alicia Narvaez Munguía query from Mexico.
Hello, good day, a question: If I have a period of time, say 5 to 7 January, and if within that time frame was not the payment will be fined $ 10 for each day that payment has been made ... How I do the formula to calculate this?
The resulting form should this:
The problem is solved by arming the conditional formula that appears in the function bar:
= IF ((D3-C3)> 0, (D3-C3) * 10, "$ 0.00")
basically subtracting dates to see the days and the result is multiplied by the daily amount of fine.
need the conditional "if" for cases in which a person pays on time or before the deadline, otherwise it would give a negative number.
0 comments:
Post a Comment