Must I Use Nested IF's for this?

[abrogard]

I don’t even know if nested IF’s are a thing in calc, but if they are…

I want to go through a list of numbers and if the number is greater than this value but less than the next value then increase it by this much, if it is greater than the next value but less than the next after it then increase it by a different amount and so on…

so that if 31 days overdue value = value x 1.02
60 days overdue value = value x 1.04
90 days overdue value = value x 1.06 that sort of thing.

[robleyd]

Use a lookup table in conjunction with e.g. VLOOKUP

[anon73440385]

Hello,

assuming that

• “list of values” means the list of overdue days defining the borders for the uplift levels: (30, 60, 90, …)
• A1 contains the overdue days,
• A2 contains the value to be uplifted

then

=IFS(A1<30;A1; A1<60;A2*1,02; A1<90;A2*1,06; TRUE();"Call an advocate")
(Note: The first matching condition applies.)

See also: LibreOffice Help - IFS

Tested using LibreOffice:

Version: 6.4.0.3, Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

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

[hwy061]

Since the limits are linear, and so is the rate of increase you could use a formula like:
=1+INT((currentDate-dueDate)/30)*0.02