K
Karen Smith
I have the following formula and the answer is coming up zero when it
shouldn't be. I think its because the last part if Y19="B." i should get a
number, but am not, so obviously somethings wrong with my formula, can
someone help me please?
=IF('The Worker Be!'!$B19="CD",0,IF(AND('The Worker Be!'!$H19="YES",'The
Worker Be!'!$G19="New"),'The Worker
Be!'!$E19*IF(OR($Y19="A.",$Y19="D."),B$2*'The Worker
Be!'!$I19,0),IF(OR($Y19="C.",B5,$Y19="B.",$B4)*'The Worker Be!'!$I19,0)))
shouldn't be. I think its because the last part if Y19="B." i should get a
number, but am not, so obviously somethings wrong with my formula, can
someone help me please?
=IF('The Worker Be!'!$B19="CD",0,IF(AND('The Worker Be!'!$H19="YES",'The
Worker Be!'!$G19="New"),'The Worker
Be!'!$E19*IF(OR($Y19="A.",$Y19="D."),B$2*'The Worker
Be!'!$I19,0),IF(OR($Y19="C.",B5,$Y19="B.",$B4)*'The Worker Be!'!$I19,0)))