Thanks:  0
Likes:  0

1. 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 If c3 > \$1001 then d3 = \$500

Thanks,
Brian

2. 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 If c3 > \$1001 then d3 = \$500

Thanks,
Brian
If cell c3 <\$600 then d3 = \$200
If \$601 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.

3. This works great if you remove the last )after 500

4. On 2002-02-25 14:30, kinkyparamour wrote:
This works great if you remove the last )after 500
That's right. A typo

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•