Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Express when $ added
The following express gave the condition of 100% when $ was missing, and when
added it gave a 0%, any reasons why? =IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF( OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="L P",$F5="RVP",$F5="UA"),1,IF(OR(AND($H5="D",$A5=Ro llUp!$AX$15,$C5=RollUp!$AY15),AND($H5="S",$A5=Ro llUp!$AX$16,$C5=RollUp!$AY16)),1,0.8))))),"") IF(OR(AND($H5="D",$A5=RollUp!$AX$15,$C5=RollUp!$ AY$15),AND($H5="S",$A5=RollUp!$AX$16,$C5=RollUp! $AY$16)),1,0.8))))),"") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Express when $ added
Rick,
I have untangling many an Excel workbook with equations like these. It s not much fun and it is really time consuming - and expensive. If you expect anyone else to be able to help you, learn how to use named ranges, decision trees and User Defined Fuctions (UDF). I have not the slightest idea of what you are trying to accomplish here? But, the compound AND statements at the end of your expression seem to contain a logic error. Sorry to be such a grump. Allan P. London, CPA "Rick" wrote in message ... The following express gave the condition of 100% when $ was missing, and when added it gave a 0%, any reasons why? =IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF( OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="L P",$F5="RVP",$F5="UA"),1,IF(OR(AND($H5="D",$A5=Ro llUp!$AX$15,$C5=RollUp!$AY15),AND($H5="S",$A5=Ro llUp!$AX$16,$C5=RollUp!$AY16)),1,0.8))))),"") IF(OR(AND($H5="D",$A5=RollUp!$AX$15,$C5=RollUp!$ AY$15),AND($H5="S",$A5=RollUp!$AX$16,$C5=RollUp! $AY$16)),1,0.8))))),"") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Express when $ added
Sorry about the tangled logic, but this workbook has about 20 sheets to it
the code I gave here is just for the accumulative analyist sheet. with columns going out to BZ356. This is a medical tracking program in Excel and I am only a beginner in VB so most of the code is in Excel. Thanks for indicating a logic error in the compound statement, I will have to study that one a little more carefully. Rick. "alondon" wrote: Rick, I have untangling many an Excel workbook with equations like these. It s not much fun and it is really time consuming - and expensive. If you expect anyone else to be able to help you, learn how to use named ranges, decision trees and User Defined Fuctions (UDF). I have not the slightest idea of what you are trying to accomplish here? But, the compound AND statements at the end of your expression seem to contain a logic error. Sorry to be such a grump. Allan P. London, CPA "Rick" wrote in message ... The following express gave the condition of 100% when $ was missing, and when added it gave a 0%, any reasons why? =IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF( OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="L P",$F5="RVP",$F5="UA"),1,IF(OR(AND($H5="D",$A5=Ro llUp!$AX$15,$C5=RollUp!$AY15),AND($H5="S",$A5=Ro llUp!$AX$16,$C5=RollUp!$AY16)),1,0.8))))),"") IF(OR(AND($H5="D",$A5=RollUp!$AX$15,$C5=RollUp!$ AY$15),AND($H5="S",$A5=RollUp!$AX$16,$C5=RollUp! $AY$16)),1,0.8))))),"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular or semi-circular chart | Charts and Charting in Excel | |||
Express a Formula that is + or - 20% from a Value Q | Excel Worksheet Functions | |||
how to express dan < using excel? | Excel Worksheet Functions | |||
out express | Setting up and Configuration of Excel | |||
How to express this in an if statement. | Excel Worksheet Functions |