Mar 21 2024 09:35 AM
Here is my formula
=IFS(D22-D18>D18,{" "},D22-D18<D18,{"0"},D22-D18=D17,{"5000000"})
It is broken at the first part, I need it to come to a number that is between $3M and $5M, how do I get a number? The following section is the one that works D22-D18<d18,{"0"}. Can anyone help with this formula, not sure what I am doing wrong.
Thank you for your assistance, much appreciated.
Mar 21 2024 09:52 AM
Mar 21 2024 10:00 AM
The only way to get "5000000" is if D18=D17 and D22=2*D17.
I doubt this is what you intend.
Other observations might be that treating scalar values as arrays {"5000000"}. Also, does the result need to be text?
Mar 21 2024 10:19 AM
this is what I am attempting to do is take the d22 less d18 if larger then the difference between d22, d18 and d17 if smaller then 0, or if it higher the d17 make it the amount in d17.
using=IFS(D22-D18>D18,"",D22-D18<D18,0,D22-D18=D17,500000)
I get the 500,000 but I can't seem to find the formula for the difference between d22-d18>d17,'"
can you help?
Mar 21 2024 10:32 AM
Mar 21 2024 01:26 PM
The now information is useful, but I still do not really understand exactly what it is you hope to see. My formula returned 500,000 but I wouldn't know whether that is good or bad.
= IFS(
paidLoss-retention > limit, limit,
paidLoss-retention < retention, 0,
TRUE, 500000
)
Mar 21 2024 02:02 PM
Mar 21 2024 02:36 PM
This tries to follow your written criteria as I followed them
= IFS(
paidLoss-retention < 0, 0,
paidLoss-retention > limit, limit,
TRUE, paidLoss-retention
)
If that is correct, an alternative formula might be
= MEDIAN(0, limit, paidLoss- retention)
[p.s. I hope that the use of names makes the formula more meaningful written here, evenif you doen't use them in your workbooks]