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 appreciated!
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 appreciated!