Formula Help
 

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)))

Formula Help
 

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)))

Formula Help
 

That last IF can only give 0. If the condition is satisfied it gives 0, and
if not it would default to FALSE.
The condition is OR($Y19="C.",B5,$Y19="B.",$B4)*'The Worker Be!'!$I19 so the
multiplication effectively gives an AND, to combine with the OR which has 4
inputs.
I doubt whether that's what you intended.
--
David Biddulph

"Karen Smith" wrote in message
...
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)))

Formula Help
 

David, what I am trying to say in the formula is if H9 is yes and g9 is new,
then if Y9 is A. or D. then b2 * "The Worker Be!"!I19, BUT if Y9 is B. then
b4 * "The Worker Be!"!I19, BUT if Y9 is C. then B5 * "The Worker Be!"!I19. I
just don't know how to say it in the formula properly. Do you know how?

"David Biddulph" wrote:

That last IF can only give 0. If the condition is satisfied it gives 0, and
if not it would default to FALSE.
The condition is OR($Y19="C.",B5,$Y19="B.",$B4)*'The Worker Be!'!$I19 so the
multiplication effectively gives an AND, to combine with the OR which has 4
inputs.
I doubt whether that's what you intended.
--
David Biddulph

"Karen Smith" wrote in message
...
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)))