Multiple Range Value Selection

[Sopha]

Hi All,

I am having trouble figuring out how to select a value in multiple ranges. Essentially I need to assign a score to the value in A3 based on the criteria. I can visually see that it should be given a score of 40 but I can't figure out how to make a formula that does that for me.

Thanks!

 

[SunnyAlv]

A3 based on the criteria

where criteria on A3 i can found ?

 

[Sopha]

where criteria on A3 i can found ?

Hi, thanks for replying so quickly. That number is being pulled from another sheet.

 

[SunnyAlv]

Hi, thanks for replying so quickly. That number is being pulled from another sheet.

hmm, can I see it?, because you include one photo without a trigger/criteria that's very confusing

 

[kevin9999]

One suggestion:

Book1
	A	B
3	$251,000.00	30
Sheet1

Cell Formulas
Range	Formula
B3	B3	=IFS(A3<=999,0,A3<=99999,10,A3<=249999,20,A3<=749999,30,A3>=750000,40)