L
Legacy 69619
Guest
Hola!!
Is there a simpler way in Excel to find a range within defined dollar amounts.
For example: I have a tier table set-up and depending on your sales you get a percentage.
Sales Percentage
$0 - $5,000 5%
$5,000 - $10,000 10%
$10,001 - $15,000 15%
I am using IF statements, and it works, except isn't there a cooler way to compute??
Thx...thx...cheers!
Miss Exel
Is there a simpler way in Excel to find a range within defined dollar amounts.
For example: I have a tier table set-up and depending on your sales you get a percentage.
Sales Percentage
$0 - $5,000 5%
$5,000 - $10,000 10%
$10,001 - $15,000 15%
I am using IF statements, and it works, except isn't there a cooler way to compute??
Thx...thx...cheers!
Miss Exel