IF AND OR Formula Help

K

KC

I'm having trouble creating a formula. Can someone help me? The info I need
in the formula is below. Thanks in advance for your help.

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
 
D

Don Guillett

See your previous posts. NOT nice to repost the same question. "Patience is
a virtue"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Formula Help Needed 7
Transfer data between two tables 3
IF Formula Help 4
Formula Help 3
IF AND FORMULA 1
IF AND Formula Help Needed 8
Creating automated timesheets 2
Newbie Help - IF Yes No Function 0

Top