August 9th, 2005, 11:13 PM
|
|
I actually got it with an AND function like this:
=IF(M7$D26,$B24*$D24+$B25*$D25+((M7-$D26)*$B26),IF(AND($D24M7,M7$D26),$B24*$D24+((M7-$D24)*$B25),IF(M7$D24,$B24*M7,0)))
"Anne Troy" wrote:
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(B740000000,$B24*B7,0)))
************
Anne Troy
www.OfficeArticles.com
"Adam" wrote in message
news
=IF(B7=50000000,$B24*$D24+$B25*$D25+((B7-$D26)*$B26),IF(COUNTIF(B7,"b7$D24,b7$D26"),$B24* 40000000+((B7-40000000)*$B25),IF(B740000000,$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?
|