simple formula

[bdgray]

I'm trying to build a formula that would reassign list pricing for a product into 3 promotional rates. Can someone help me turn this into something excel can understand?

If cell c3 <$600 then d3 = $200
If $601<c3<$1000 then d3 = $350
If c3 > $1001 then d3 = $500

Thanks,
Brian

 

[Aladin Akyurek]

On 2002-02-25 13:38, bdgray wrote:
I'm trying to build a formula that would reassign list pricing for a product into 3 promotional rates. Can someone help me turn this into something excel can understand?

If cell c3 <$600 then d3 = $200
If $601<c3<$1000 then d3 = $350
If c3 > $1001 then d3 = $500

Thanks,
Brian

If cell c3 <$600 then d3 = $200
If $601<c3<$1000 then d3 = $350
If c3 > $1001 then d3 = $500

In D3 enter:

=(C3<=600)*200+(c3>600)*(C3<=1000)*350+(C3>1000)*500)

This one is without IFs.

 

[kinkyparamour]

This works great if you remove the last )after 500

 

[Aladin Akyurek]

On 2002-02-25 14:30, kinkyparamour wrote:
This works great if you remove the last )after 500

That's right. A typo