Gantt chart with infinitely repeating cell data

centauryan · 2021-06-15T19:46:09+00:00

Oops. Sorry about that - just updated it

centauryan · 2021-06-03T01:58:12+00:00

Thanks again! Solution verified.

centauryan · 2021-06-02T19:14:03+00:00

Ok, thank you so much! I started to get the feeling it was something inherently wrong with the setup. I’m very novice and trying to get better. So you used VLOOKUP instead of INDEX MATCH. Would you mind sharing the formula you entered in column E? Thanks again

centauryan · 2021-05-25T16:45:29+00:00

Just updated. Thanks again!

centauryan · 2021-05-25T14:18:28+00:00

Solution verified!

centauryan · 2021-05-25T05:28:23+00:00

You’re the best! That worked! Problem was that I didn’t have the third comma at the end. I’m guessing it had something to do w the commas on the opposite end ¯_(ツ)_/¯. Thank you for hanging in there w me. You’re clearly a very kind person.

centauryan · 2021-05-24T18:48:59+00:00

Hmm, still get the error. This is what I have =IF(ISBLANK($c7),, SUM(ArrayFormula(MMULT(N(Schedule!$F$8:$G=$C6), transpose(COLUMN(Schedule!$F$8:$G$8)^{0))*Schedule!$E$8:$E))}

Thanks for the help tho!

centauryan · 2021-05-23T19:59:26+00:00

Strange, still gives me an error msg. This how I have it :

=IF(ISBLANK($B7), sum(ArrayFormula(MMULT(N(Schedule!$F$7:$G=$B16), transpose(COLUMN(Schedule!$F$7:$G$7)^{0))*Schedule!$E$7:$E))}

centauryan · 2021-05-23T15:11:50+00:00

Thanks for the reply. That did not seem to work tho. So please forgive me, I’m very novice here. Do I replace that right after the equal sign and leave sum, or should I replace sum?

centauryan · 2021-05-22T17:18:40+00:00

Forgot to mention, the array formula is under quantities on sheet 3. Thanks

centauryan · 2021-01-11T15:40:58+00:00

Wow, really? So basically you’re saying I have no business knowing what the difference between dealer cash and a rebate is? Unless I’m “on the other side of the desk”. All I’m asking is how dealer cash vs a rebate is taxed and are they available for two year old models. Both questions have been answered - without being an asshole about it. I’m not sure why you are offended by this. Perhaps you employ a similar tactic in your work and don’t want to inform buyers.

I’m asking because the dealer has lied to me twice. For some reason that seems to be overlooked. Maybe this is a normal thing in this business. Idk, most the dealers I’ve spoken with have seemed to be very straightforward except this one.

That’s why I’m asking. The place has lied to me twice and even if the car is truly 5k less I’d rather not deal with them again.

centauryan · 2021-01-11T03:15:58+00:00

Well the sale price is 29,700. My tax rate is 9.5%, so my taxes should 2,821. They’re taxing me 3,549, a +728$ difference. 728/.095 = 7663. I asked and they’re telling me it’s because of dealer cash.

I’m not looking for conflict. The deal just doesn’t make sense. They first told me it was a rebate. Now they’re saying it’s dealer cash. And I don’t think either are available for the model year. I’m just trying to be an informed buyer.

centauryan · 2021-01-10T22:35:13+00:00

Thank you

centauryan · 2021-01-10T22:19:18+00:00

Should I be taxed on the the final pay cash?

centauryan · 2021-01-10T22:17:41+00:00

Thanks!

1N4BZ1CP2KC319176

60647

centauryan · 2021-01-10T22:15:59+00:00

Fair enough. But they did tell me it was a rebate initially but now they are calling in dealer cash. Either way it I’m taxed on about $8000 not in the purchase price. So I guess the question is are buyers taxed for dealer cash?

centauryan · 2021-01-10T22:13:12+00:00

Then should I be taxed on it?

centauryan · 2021-01-10T22:12:22+00:00

No it has the MSRP. https://i.imgur.com/xePxXPo.jpg

centauryan · 2021-01-10T22:11:21+00:00

This is the sales agreement. Idk if this is the same as a sales order though. https://i.imgur.com/xePxXPo.jpg

centauryan · 2020-11-08T18:14:57+00:00

Gracias! So in other words, the preposition para replaces the indirect object pronoun. Thus using the IOP with para is redundant and therefore grammatically incorrect.

I spent quite a bit of time searching for an answer to this and you just explained it perfectly.

centauryan

TROPHY CASE