| 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))))),"") |
| 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 | |||
Threaded Mode
