The only thing i can see is this
IF(OR($Y19="C.",B5,$Y19="B.",$B4)*'The Worker Be!'!$I19,0
you are entering 3 or's, the middle one, B5 is not a logical, it should be
something like B5="D." or something similar like the others. I think you just
left a piece out.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Karen Smith" wrote:

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)*'Th e Worker Be!'!$I19,0)))