LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default IF AND OR Formula Help

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"