R
Rick
I need to test different issue's within a cell. Here is an example. When I
speak of levels it is in reference to actual levels not the number of IF's.
=IF($G5="M","T1",0)
"T1"
IF(OR(YEAR($B5)=$AU$3,$F5="Full",$F5="BMP",$F5="CBC",$F5="RVP",$F5="UA"),0,"F2")
" F2" IF($H5="D","T3","F3")
"T3" IF($U5="Yes",$AV326,"F4")
"F4" IF($B5>RollUp!$AR$15,0,"F5")
"F5" IF($B5<RollUp!$AR$15,$K5,"F6")
"F6" IF(SUM(Activity!$AM$326+$K5)<RollUp!$AT$6,$K5,SUM($K11*0.2))
speak of levels it is in reference to actual levels not the number of IF's.
=IF($G5="M","T1",0)
"T1"
IF(OR(YEAR($B5)=$AU$3,$F5="Full",$F5="BMP",$F5="CBC",$F5="RVP",$F5="UA"),0,"F2")
" F2" IF($H5="D","T3","F3")
"T3" IF($U5="Yes",$AV326,"F4")
"F4" IF($B5>RollUp!$AR$15,0,"F5")
"F5" IF($B5<RollUp!$AR$15,$K5,"F6")
"F6" IF(SUM(Activity!$AM$326+$K5)<RollUp!$AT$6,$K5,SUM($K11*0.2))