K
Karen Smith
Can someone help me create a formula for:
If tab "Worker Be" cell B9 = "CD" and
"Worker Be" cell J9 is empty and
Y9 (on current tab) does not = "C."
then the answer should be zero
then
If tab "Worker Be" B9 = "SM" and
"Worker Be" H9 = "Yes" and
if "Worker Be" J9 = either "Big Word" or "WTOO" or "Global Doc"
than ("Worker Be" E9 * $22.50 plus "Worker Be" AF9 * $200) * "Worker Be" I9
otherwise the answer should be zero
If tab "Worker Be" cell B9 = "CD" and
"Worker Be" cell J9 is empty and
Y9 (on current tab) does not = "C."
then the answer should be zero
then
If tab "Worker Be" B9 = "SM" and
"Worker Be" H9 = "Yes" and
if "Worker Be" J9 = either "Big Word" or "WTOO" or "Global Doc"
than ("Worker Be" E9 * $22.50 plus "Worker Be" AF9 * $200) * "Worker Be" I9
otherwise the answer should be zero