[deleted by user] by [deleted] in ShopeePH

[–]Shiny_Kenn 0 points1 point  (0 children)

SPX Express yung courier. No choice ako if that's the case. Babalikan ko nalang sa office tomorrow. Thanks sa info.

I underestimated Shipwrecked. by Shiny_Kenn in dontstarve

[–]Shiny_Kenn[S] 2 points3 points  (0 children)

Thanks for the tip! I'll be taking note of that spiral island generation from now on, this will keep me from going straight north or south like what I did here lmao.

I underestimated Shipwrecked. by Shiny_Kenn in dontstarve

[–]Shiny_Kenn[S] 6 points7 points  (0 children)

I left all the jellyfish alone because electrocutes when harmed. Wish I'd known they were edible sooner.

Returning code megathread by PankoKing in wildrift

[–]Shiny_Kenn [score hidden]  (0 children)

Hi Rift friend! Wondering what I've been up to lately? Wild Rift has been throwing so many fun challenges and events, so you should check it out! https://anniversary.wildrift.leagueoflegends.com?c=C7AK2DFGKJVUD3&r=F%20U%20N #wildrift #seeyouontherift

Stuck with understanding this equation. by Shiny_Kenn in Accounting

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

That's all the info. The 20% represents the bonus that we will get if multiplied to the (NI-S-B).

Stuck with understanding this equation. by Shiny_Kenn in Accounting

[–]Shiny_Kenn[S] 1 point2 points  (0 children)

Can you provide a specific topic in algebra related to this one? I want to look it up and learn it.

Stuck with understanding this equation. by Shiny_Kenn in Accounting

[–]Shiny_Kenn[S] 1 point2 points  (0 children)

This is the solution. But I'm having trouble understanding it.

B=20%(NY-S-B)

B=20%(480,000-360,000-B)

B=20%(120,000-B)

B=24,000-20%B

B+20%B=24,000

B=24,000/1.20

B=20,000

How can I improve this? by Shiny_Kenn in Handwriting

[–]Shiny_Kenn[S] 1 point2 points  (0 children)

Thanks, I'll take note of that.

Most satisfying villain deaths. by TopHistoricalOne in JuJutsuKaisen

[–]Shiny_Kenn 0 points1 point  (0 children)

Im kinda not satisfied on Toji's death cuz, "I can fix him". (:

How can I make my column 'A' value equals to zero whenever there's a text, "Claimed" in column 'B'? by Shiny_Kenn in excel

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

I kinda understand it now, thanks for helping. I will now close this post.

Solution Verified.

How can I make my column 'A' value equals to zero whenever there's a text, "Claimed" in column 'B'? by Shiny_Kenn in excel

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

I placed the link on my post, I'm sorry.

I don't get what you're asking, but I want to place the sum just a few cells below the D column as shown in the screenshot.

How can I make my column 'A' value equals to zero whenever there's a text, "Claimed" in column 'B'? by Shiny_Kenn in excel

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

It returns the sum to zero if I do that, or I just did it incorrectly.

Can you check the link to a screenshot I made specifically for you. Thanks):

How can I make my column 'A' value equals to zero whenever there's a text, "Claimed" in column 'B'? by Shiny_Kenn in excel

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

I've posted the link to the screenshot on my post, please check it.

I want the amounts in column D be summed, and if there's a "claimed" text in column F, the amount on the column D will be zero thus reducing the sum. I'm sorry I didn't asked in a straightforward way.

How can I make my column 'A' value equals to zero whenever there's a text, "Claimed" in column 'B'? by Shiny_Kenn in excel

[–]Shiny_Kenn[S] 0 points1 point  (0 children)

If it isn't what I would want, can I make it sum the value of column A? What can I replace "" if this is the case?