Help with a formula

A

Adam

=IF(B7>=50000000,$B24*$D24+$B25*$D25+((B7-$D26)*$B26),IF(COUNTIF(B7,"b7>$D24,b7<$D26"),$B24*40000000+((B7-40000000)*$B25),IF(B7<40000000,$B24*B7,0)))

The issue I'm having with this formula is the greater than x but less than y
if statement. For some reason it won't recognize it. I tried the countif
formula, but no luck. Anyone know how to fix this?
 
A

Anne Troy

Try this:
=IF(B7>=50000000,$B24*$D24+$B25*$D25+((B7-$D26)*$B26),IF(OR(countif(b7,">$D24"),countif(b7,"<$D26")),$B24*40000000+((B7-40000000)*$B25),IF(B7<40000000,$B24*B7,0)))
************
Anne Troy
www.OfficeArticles.com
 
A

Adam

I actually got it with an AND function like this:

=IF(M7>$D26,$B24*$D24+$B25*$D25+((M7-$D26)*$B26),IF(AND($D24<M7,M7<$D26),$B24*$D24+((M7-$D24)*$B25),IF(M7<$D24,$B24*M7,0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a formula (calculating totals based on individual percentages 7
Finding the weighted average of text that have been given values 1
if command with tiers 2
Yet another extremely complex IF statement 1
Extremely complex IF statements 5
[CSE] SUM Array Formula with if condition 1
Formula Cell color limitation 7
Help with a multi if then else formula. 5

Top