Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF AND Formula Help Needed
I have 2 formulas that I need to add another condition to and everytime I try
it, it doesn't work. Both formulas also need to say: If 'The Worker Be!'!B8=CD then do nothing with the formulas below. Formula 1: =IF(AND($S8="A.",'The Worker Be!'!$G8="New"),$B$2*'The Worker Be!'!$F8,0)+IF(AND($S8="A.",'The Worker Be!'!$G8="Update"),$B$3*'The Worker Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="New"),$B$2*'The Worker Be!'!$F8,0)+IF(AND($S8="B.",'The Worker Be!'!$G8="Update"),B3*'The Worker Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="New"),$B$5*'The Worker Be!'!$F8,0)+IF(AND($S8="C.",'The Worker Be!'!$G8="Update"),$B$5*'The Worker Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="New"),$B$4*'The Worker Be!'!$F8,0)+IF(AND($S8="D.",'The Worker Be!'!$G8="Update"),$B$4*'The Worker Be!'!$F8,0) Formula 2: =IF(AND(S8="A.",'The Worker Be!'!K8="X"),$D$3*'The Worker Be!'!$F8,0)+IF(AND(S8="B.",'The Worker Be!'!K$8="X"),$D$3*'The Worker Be!'!$F8,0)+IF(AND(S8="C.",'The Worker Be!'!$K8="X"),$D$4*'The Worker Be!'!$F8,0)+IF(AND(S8="D.",'The Worker Be!'!$K8="X"),$D$3*'The Worker Be!'!$F8,0) Any one have any ideas? Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions | |||
Formula help needed | Excel Worksheet Functions | |||
Formula Set Up Needed | Charts and Charting in Excel | |||
Formula Needed! | Excel Discussion (Misc queries) |