Functions/Formulas in Numbers
I want to have a total value increase, by a specified amount, after every period of 7 days. Is there a formula or function in numbers that will do it?
iPad, iPadOS 17
I want to have a total value increase, by a specified amount, after every period of 7 days. Is there a formula or function in numbers that will do it?
iPad, iPadOS 17
If I understand you correctly then you can try something like this:
=B3+B4*QUOTIENT(TODAY()−B2,"7d")
If the word for day in your language begins with a letter other than d then use that letter instead.
Use ; instead of , in the formula if your regions uses , as the decimal separator.
SG
Functions/Formulas in Numbers