Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
=IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312)
What I'm attempting to do€¦ If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
On Sep 12, 2:20 pm, MarvInBoise
wrote: =IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312) What I'm attempting to do… If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk Couple changes, and I threw in an instruction if False: =IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG") ,L311/1.5,"") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
=IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG") ,L311/1.5,L311)
"MarvInBoise" wrote in message ... =IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312) What I'm attempting to do. If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
Try this:
=AND(A2=A3,I2=I3,J2="OPT",J3="REG")*L2/1.5 -- Biff Microsoft Excel MVP "MarvInBoise" wrote in message ... =IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312) What I'm attempting to do. If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
maybe
IF(AND(A311=A312,I311=I312,J311="OTP",J312="REG"), L311/1.5,result if false) "MarvInBoise" wrote: =IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312) What I'm attempting to do€¦ If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Level "and" fucntion help!
Put this in L312
=IF(AND(A311=A312,I311=I312),IF(AND(J311="OTP",J31 2="REG"),L311/1.5,""),"") "MarvInBoise" wrote: =IF(AND(A311=A312,I311=I312),(J311=OTP,J312=REG),L 311/1.5=L312) What I'm attempting to do€¦ If the EmplID is the same on A2 and A3 and the and Pay dates are equal on I2 and I3 and the Paycode on line J2 is OPT and J3 is REG then (and only then) divide the payrate L2(OTP) by 1.5. -- Marv Lusk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
Can I copy the formatting of a cell in a IF Fucntion "VLOOKUP"? | Excel Worksheet Functions |