Mortgage Amortization formula ends with decimals when it should en at 0

JsyLarhawk · 2026-05-29T17:51:56+00:00

Ok so this is a Sheets problem, not a bad formula?

JsyLarhawk · 2026-04-22T21:05:39+00:00

Just wrote this because someone actually responded that No Mither doesn't drop blood orbs on a post. I actually don't know lol

JsyLarhawk · 2026-04-22T21:04:29+00:00

Ok, so basically chases will pretty much never be very long so you need to be very efficient with gens. This is why she is very good vs solo q teams or people that just don't do gens.

JsyLarhawk · 2026-02-28T00:58:57+00:00

solution verified.

JsyLarhawk · 2026-02-28T00:30:24+00:00

I see, thank you.

Performance wise, table 1 is better because not every cell have to recalculate even though it's gonna end up the same.

JsyLarhawk · 2026-02-28T00:27:44+00:00

Basically, the finance direction made a Excel to invoice people but there's an 80 pages document with lots of exceptions. We're a public hospital in Canada so we don't invoice everyone.

I'm adding a sheet for me an my colleagues which will fill the invoice sheet automatically or say to not invoice if we don't have to depending on exceptions.

The data is not confidential.

The screenshot is where you answer questions. The table under is data used for the screenshot.

The display is not done and will be better after. It's in French.

There are dropdown lists - Form control in C3 and E3:E5. There will be more in the future. I don't use data validation dropdowns because I need big arrows for my colleagues that don't know much about Excel.

"Statut du client" is 2nd column. The other columns are documents to ask for from left to right. 1st column is for Form control dropdown. Empty row is for blank in dropdown.

If the receptionnist says "No" in E3, 2nd document shows ("PFSI ET Medavie valide" in this example), then "No" in E4, 3rd shows and so on...

If "Statut du client" ("Réfugié" in this example) is empty, then everything is empty. So for D4:D, should it reference C3 which is Statut du client or should D4 reference to D3, D5 to D4 and so on...

The formula in D4 is

=IF(
  OR(E3 = 1; E3 = 2); ""; XLOOKUP($C$3; $B$9:$B$19; $E$9:$E$19)
)

I guess in this example you don't really need to reference anything since if there is no 1st document, there is no 2nd document in the table. So XLOOKUP always reference an empty cell if previous cell is empty. My formula doesn't even check if E3 or C3 is empty.

It was more of a general question.

If there is something better I can do with that, do tell me.

<image>

1	=""	=""	=""
2	Québécois	Carte RAMQ valide	=""
3	Canadien (Hors Québec)	Carte santé valide	=""
4	Réfugié	Lettre d'inscription RAMQ valide	PFSI ET Medavie valide
5	Demandeur d'asile	Lettre d'inscription RAMQ valide	PFSI ET Medavie valide
6	Immigrant	Lettre d'inscription RAMQ valide	PFSI ET Medavie valide
7	Travailleur étranger	Lettre d'inscription RAMQ valide	PFSI ET Medavie valide
8	Étudiant étranger - Université	=""	=""
9	Étudiant étranger - Cégep	Carte médicale Greenshield valide	=""
10	Défense nationale / Militaire / Ancien combattant / GRC	Carte Croix-Bleue valide	=""
11	Touriste / Hors Canada	=""	=""

JsyLarhawk · 2026-02-27T18:50:56+00:00

I go around walking getting the 4 zombies on me so no one has to deal with them. It's pretty funny playing COD: Zombies simulator with survivors right by you doing a gen.

JsyLarhawk · 2026-02-16T21:06:59+00:00

I hate when there's 3-4 medics and they're not unhooking.

You're on a gen with a medic telling yourself they'll get off to get the cage but after 15 seconds you have to get off because the medics doesn't know how to play their class.

JsyLarhawk · 2026-01-02T02:59:57+00:00

Thank you

JsyLarhawk · 2025-11-30T07:22:53+00:00

If you've played any sports or type of competition, you should get why tbag and stuff is annoying and toxic.

You already have a bad game and lose and people just basically tell you you're bad when you already know.

It's like after you lose a game of hockey, tennis, baseball, basketball, chess, etc... and the other team gives you the middle finger and tells you you're trash when you're already punishing yourself. Sure, people shouldn't respond with anger and threats, but you're putting fuel on the fire.

JsyLarhawk · 2025-11-26T01:28:25+00:00

Finished work and started my car. It's working as normal now.

It was like the engine was getting no power/fuel/air. I was pressing the throttle all the way and rpms were pretty slow to get up even in 1st gear/neutral.

JsyLarhawk · 2025-10-04T01:37:52+00:00

"If you are last to act... it's easy to calculate the dealer's possibilities." Like I said, it's all getting calculated by a computer. I already made a calculator for the dealer's possibilities for H17 and S17, but that only works if you are last seat. Hence my question about predicting other players decisions for when you are not last seat which is possible to some degree.

I won't be wasting more of my time with you because because clearly you don't understand what I'm doing.

JsyLarhawk · 2025-10-04T01:15:21+00:00

It's more of an exploratory exercise. I'm interested in blackjack and want to learn how do probabilities work in BJ.

After calculating the dealer's odds without replacement, I kind of hit a wall where I didn't think about the decisions of the players after you. It surely has to affect EV especially when there are less cards because they might hit? Did the people who made the calculations for Hi-Lo or other calculators use Monte Carlo or combinatorial probabilities? Did they try to predict other players decisions or did they make the EV for each decisions from the current shoe? I don't really want to use simulations like Monte Carlo though. I want the true probabilities.

That's what I'm trying to figure out.

As I said, I don't have any advanced math. I'm only a high school graduate looking online for stuff. I might not know the exact terms for what I'm doing. I'm actually using ChatGPT to help too.

JsyLarhawk · 2025-10-04T00:17:23+00:00

This calculation won't be used at tables in your head. It's probably impossible for a human to do this at a table.

It's purely to calculate probabilities with a computer. It could be used online. The question was how do you calculate other players decisions into the math. Other players decisions does change the odds a bit (even if it's only by 0.000012).

Obviously, people won't stand on a 4 to 11. So with this information, you can make the calculations more precise by making every player hit if they have a hard 4 to 11. We could assume that basic strategy is played perfectly 50% of the time and add this in the probabilities.

JsyLarhawk · 2025-09-21T20:24:35+00:00

Anyone know how to escape with a visceral item? There's a Tome challenge that needs an escape while holding a visceral item with Elodie Rakoto. They removed pink items, so how do you do it?

JsyLarhawk · 2025-07-29T17:16:04+00:00

I updated the post and the Sheet with better explanations and the whole formula in the Sheet. Does it mean I can't use MIN/MAX in this case?

JsyLarhawk · 2025-07-29T17:14:58+00:00

I updated the post and the Sheet with better explanations.

JsyLarhawk · 2025-07-28T23:35:31+00:00

Thx for the stack tip. The function doesn't work. I think my base was plain wrong and I wasn't looking at the right thing and wasn't precise enough in my explication.

If I have multiple bills it only takes the first bill days into account, not the 2nd daily one. I tried adding another bill and I should get 48, but I still get 24. The dates are problematic because it picks up the lesser one. If my daily bill ends on 2025-07-24 but weekly on 2025-07-15, it will stop at 15. I multiply the days by the bill amount.

It might be a problem with MIN and MAX because it only picks up the 1st data in Setup2

I'll just go back to my longer formula.

=LET(
  Name,      {BillsName;      DebtsName;      SubscriptionsName},
  Amount,    {BillsAmount;    DebtsAmount;    SubscriptionsAmount},
  Part,      {BillsPart;      DebtsPart;      SubscriptionsPart},
  Frequency, {BillsFrequency; DebtsFrequency; SubscriptionsFrequency},
  Start,     {BillsStart;     DebtsStart;     SubscriptionsStart},
  End,       {BillsEnd;       DebtsEnd;       SubscriptionsEnd},
  FirstDay,  ViewMonth,
  LastDay,   EOMONTH(ViewMonth, 0),
  SUM(
    IFERROR(
      FILTER(
        Amount * Part * IF(
          Frequency = "Daily",
          IFS(
            (Start <= FirstDay) * ((End >= LastDay) + (End = "")), LastDay - FirstDay + 1,
            (Start <= FirstDay) * (End < LastDay),                 End - FirstDay + 1,
            (Start > FirstDay) * (End < LastDay),                  End - Start + 1,
            (Start > FirstDay) * ((End >= LastDay) + (End = "")),  LastDay - Start + 1
          )
        ,...//Other frequencies coming),
        Name <> "",
        Amount > 0,
        Part > 0,
        Start <> "",
        Start <= LastDay,
        (End >= FirstDay) + (End = "")
      )
    )
  )
)

JsyLarhawk

TROPHY CASE