• 396K Members
• 8,679 Online
• 429K Conversations

Logical Formulas

Occasional Visitor

Logical Formulas

Hello,

I am working on a project and I am needing to reference three different ranges(prices) of cells based on pricing levels below. I have seven different prices/parts I need to have a formula to add together and total and when it hits \$2501-\$10,000 it needs to use the second range of prices, and the third range of pricing for total @ and over \$25,000

=>2500

>10,000<

=<25,000

Thank you,

Joshua

2 Replies

Re: Logical Formulas

You stated "I need to have a formula to add together and total and when it hits \$2501-\$10,000 it needs to use the second range of prices, and the third range of pricing for total @ and over \$25,000"

What does "it" refer to? It cannot refer to total in your sample file because it will result in circular reference error

Re: Logical Formulas

@jmorr08u , that could be

```=G2*IF(SUMPRODUCT(\$G\$2:\$G\$8*\$L\$2:\$L\$8)>\$L\$1,\$K2,
IF(SUMPRODUCT(\$G\$2:\$G\$8*\$M\$2:\$M\$8)>\$M\$1,\$L2,\$M2))```

in I2 and drag it down. I removed multiplier 100 in initial formula since it wasn't explained how to use it, Cost=Qty*Price here

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies