$50

Hi All, I have a formula I am having a heck of a time with, I need this to say, E8+E11*6% for the first 5000 and then over 5000 would then be charged 6%. The catch is I need it to retain the amount of the 1% for the first 5000 ($50) E8+E11)*7% Eg 5000 would result in $350 Eg 6750 would...

Good morning I am creating a spreadsheet that needs the following and I'm having trouble creating this formula. I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another...

Column A3 is a basketball player's name, B3 is his salary for the day and column J are his projected stats for the day. I need to find the top 8 scores of column J that equal $50,000 from column B3. I also need their names (from column A3) associated with the results. The results can be placed...

Hi everyone! Have a question which I've been struggling with for a while today. I'll try and keep this short. Not asking anyone to write the formula for me, just point me in the right direction if possible. (A) I have a target bonus payment totaling $50,000. (B) I have a sales target of...

A B C 1 1/2/17 Meals $50 2 2/2/17 Office $100 3 Other $200 Sum C1:C3 IF B1:B3 AND IF A1:A3 occurred in 1(January). The answer should be $50. It should ONLY SUM C where B says meals (B1) and A says "1" (A1). I have tried some...

Hello all, I am looking for a macro that would convert a horizontal list to a vertical one. All I can come up with is a macro to copy the row and paste it X number of times, but my list contains thousands of rows and doesn't seem very practical. Assuming ID column is column A: <tbody> A ---...

Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work:confused: <tbody> Away Home $50 TRUE Home Away Home $75 TRUE Away Away Home $100 TRUE Away...

Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work :confused: <tbody> Home Away $50 True Away Home Away $75 True Home Home Away $100 True Home...

i have a 100 transactions - 50 with a debit and 50 with a credit amount in 2 separate columns, i want to identify where each of the amounts land up in the following categories - <tbody> $0 - $2,500 $2,500 - $10,000 $10,000 - $50,000 $50,000 - $100,000 $100,000 - $250,000 $250,000 -...

Hi All! I'm looking to return a different value based on whether cell C35 is between multiple ranges... i.e.: ($0-$25,000 = $500); ($25,001-$50,000 = $1000); ($50,001 -100,000 = $1,500); (100,001+ = 2,000) I've tried (and failed) at various nest IFs and lookups... any help is sincerely...

I'm creating a 2018 budget spreadsheet against which I'll track invoices for burndown charts. My budget rows are created as LineID Vendor etc etc Jan Feb Mar ... Dec Total XY001 IBM $50 $50 $100 $50 $xxx AM005...

Hi all, I am getting stuck on how and or what may be the best way to navigate this data. I have values for injuries and I want to know how much shoulder injuries cost in 2015 and 2016. Imagine if you will; <tbody> 2015 Type of injury Body Part Nature of injury Total Medical...

Hi all, I'm new to the forum. So I've never done formulas before & I want to create one. I need the total amount on the sheet (would it go at the top?) & then I will add the expenses in the rows (I assume it's one expense per line), & then as they are added, they subtract from the total &...