Challenge
Try this:
=IF(SUM(COUNTIF(BE229,{3,4,5,6,7})),AK229*CHOOSE(B E229-2,Input!$G$10,Input!$G$11,Input!$G$13,Input!$G$14, Input!$G$15),0)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"OwenGiryluk" <u37865@uwe wrote in message news:790d3d9f06f38@uwe...
=IF(BG229=0,IF(BE229=3,AK229*(0+Input!$G$10),IF(BE 229=4,AK229*(0+Input!$G$11),
IF(BE229=5,AK229*(0+Input!$G$13),IF(BE229=6,AK229* (0+Input!$G$14),IF(BE229=7,
AK229*(0+Input!$G$15),0))))))
This formula returns a "FALSE" statement if not true. Anyway to change
the
formula to return a zero if FALSE. THANKS...
|