Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |