If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with a formula
=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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding row to forumla | carrera | General Discussion | 9 | August 23rd, 2005 10:24 PM |
Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Formula for comparison of Three Teams | Rashid Khan | Worksheet Functions | 8 | May 31st, 2004 07:32 PM |
generating formula with a formula | Lisa Linard | Worksheet Functions | 2 | November 27th, 2003 01:03 PM |