# Multiples formula

#### Ufoo

##### Member
Hello excel community, I have struggled to develop 1 conditional formula for multiples as indicated in the attached excel sheet. Kindly please help with that. Thanks in advance for your help

#### Attachments

• 9.2 KB Views: 9

#### pecoflyer

##### Well-Known Member
Could you explain a bit more please, this is not quite clear to me

#### Ufoo

##### Member
Could you explain a bit more please, this is not quite clear to me
I am attaching another excel sheet with more detailed explanation. Thanks a lot

#### Attachments

• 8.6 KB Views: 8

#### p45cal

##### Well-Known Member
try in cell B4:
Code:
=INDEX({0.001,0.002,0.003,0.004,0.005,0},MATCH(B3,{0,200,300,400,500,1000}))+INT(B3/1000)/100
copied to the right.

#### Ufoo

##### Member
try in cell B4:
Code:
=INDEX({0.001,0.002,0.003,0.004,0.005,0},MATCH(B3,{0,200,300,400,500,1000}))+INT(B3/1000)/100
copied to the right.
Works perfectly. Thanks a lot

#### pecoflyer

##### Well-Known Member
A solution independent of an array of values
=(MIN(FLOOR(B3,100),500)*(B3<1000)+FLOOR(B3,1000)*(B3>=1000))/100000

#### p45cal

##### Well-Known Member
A solution independent of an array of values
Check values less than 100

#### pecoflyer

##### Well-Known Member
Check values less than 100
Good point. I suppose you found an answer ?