| Home |
| Search |
| Today's Posts |
|
#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(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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
