if/then variable multipliers

[TC]

I have a single cell input for total revenues. I need to
create a formula that allows for 4 different possible
multipliers from that number. For example:
If revenues are between $100MM and $250MM, the multiplier
will be 0.001.
If revenues are >250MM and <350MM, the multiplier will be
0.0015.
If revenues are >350MM and <500MM, the multiplier will be
0.002.
If revenues are >500MM, the multiplier will be 0.0025.
Thanks for your help.

 

[Govind]

Hi,

Try

=IF(A1>500,0.0025,IF(A1>350,0.002,IF(A1>250,0.015,IF(A1>100,0.001,0))))


Regards

Govind.

 

[Frank Kabel]

Hi
try
=MIN(0.001+INT((A1-100)/150)*0.0005,0.0025)

you've not defined what should happen with values wsuch as 350. I
ssumed you have ranges such as