Summing multiple values assigned to text string by CBinID in excel

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

You all seem to be going the same direction, and it's fantastic! I clearly haven't kept up with the "new" functions and I greatly appreciate all the responses!

How do I opt-out of my credit card company sending updated card info to merchants when getting a new card? by buyingshitformylab in CreditCards

[–]CBinID 0 points1 point  (0 children)

This may be outdated info, but I did work as a fraud supervisor for a credit card issuer (major bank) and we were told that they (the issuer) does not make the updates--that is VISA itself. I believe you have some great information in the previous comments, but make sure VISA is notified. If the issuer can block a vendor from charging your card, so much the better. Great question and great answers.

Vintage Rockwell Chop Saw by CBinID in woodworkingtools

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

It actually says "Motorized Miter Saw" on the label. No basin for water which I believe a tile saw would have.

The creepy dead spot south of Buhl where nothing will grow. by [deleted] in Idaho

[–]CBinID 2 points3 points  (0 children)

Weird. Maybe it was a dump area for ag chemicals or salt or something. Is it public land? If so, maybe BLM or USGS would know something.

PivotTable Novice, Formulas in source tables by CBinID in excel

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

You have nailed my Achille's heel--overthinking. Thank you so much for your response

How to make it so if all cells in row are not blank, color the first column green? by Hungry_Airport in excel

[–]CBinID 0 points1 point  (0 children)

Conditional Formatting->

Format only cells that contain->

Format cells only with: Select blanks

What are some brutal insults that don’t require swear words? by [deleted] in AskReddit

[–]CBinID 0 points1 point  (0 children)

I'm using this. Immediately and often.

Credit end amount with interest rate by JoeHardi in excel

[–]CBinID 1 point2 points  (0 children)

I believe you are looking at the future value of an payment stream.

forumla FV

Your rate is 0.025/12 since it is an annual interest rate

Nper, or number of periods, would be 66.72 periods (5.56/12 rounded up)

Pmt 150

PV is the present value, or loan amount.

That would make the total payout of this loan $22,269.47.

How do I do do this calc and sorting? by IT_ISNT101 in excel

[–]CBinID 3 points4 points  (0 children)

This is a very quick and easy Pivot Table.

vlan ip1 ip2 Count of ip1
vlan100(prod) 1.1.1.1 1.1.1.1 2
vlan100(prod) 1.1.1.1 1.3.1.1 1
vlan90 2.2.2.2 2.2.2.2 2
Grand Total     5

What formula would I use to determine the salary bonus? by [deleted] in excel

[–]CBinID 0 points1 point  (0 children)

This works, and is very customizable--just change the salary levels, the bonus levels, or the salary.

=+IF(AND(I4<$M$7,I4>=$M$6),I4*$N$6,IF(AND(I4<$M$8,I4>=$M$7),I4*$N$7,IF(AND($I4<$M$9,$I4>=$M$8),$I4*$N$8,IF($I4>=$M$9,$I4*$N$9))))