| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compound if equation?
"Steve" wrote in message ... Howdee all. Hope everyone's afternoon, evening, etc... are going well. I have a dual worksheet function that requires something more compound that I've used before. Thus far, I've tried using an if equation, that looks through a dataset with a sumproduct, and if the dataset matches, I perform one equation, and if not, another. E.g., =IF(SUMPRODUCT((APN!$E$4:$E$95&""=$A11&"")*(APN!$F $4:$F$95=$C11)*(APN!$B$4:$B$95))<0,SUMPRODUCT((AP N!$E$4:$E$95&""=$A11&"")*(APN!$F$4:$F$95=$C11)*(AP N!$B$4:$B$95))/TRIM(LEFT($F$6,4))*$E$6,SUMPRODUCT((APN!$E$97:$E$1 73&""=$A11&"")*(APN!$F$97:$F$173=$C11)*(APN!$B$97: $B$173))/TRIM(LEFT($F$7,4))*$E$7) The issue that I've found is that there is a handful of datum that has values in both ranges-- 4 through 95, AND 97 through 173. This would require me to have both equations. What would be a better way to handle this? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compound Document | Excel Discussion (Misc queries) | |||
| Compound If, And Or - can | Excel Discussion (Misc queries) | |||
| compound | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Compound Interest | Excel Worksheet Functions | |||
Threaded Mode
