On the final part of a spreadsheet I'm working on, I want to pull in data from the win/loss column only if it meets the criteria of a Tier 3 loss (Greater than -$3.01 but less than -$1.99). For the example below, the only one that should be pulled into a Tier 3 Loss is the -$2.64. I am trying to do an IF A7 is greater than -$3.01 but less than -$1.99, then A7 formula but can't quite nail it. Any suggestions?
Hmm--I actually have 6 "tiers" or categories that I wanted to pull into. See below. I wanted to set up formulas in the Tier columns to pull in from the win/loss column based on how much the win or loss was. So I wanted it to look like this below. For example, on the first row, $1.96 win, could here be a formulat that says "If the amount in A3 is greater to or equal to $1.00, and greater to or less than $1.99, populate this cell with A3". Possible?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.