Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can someone fix this IF(AND) for me?
=IF(B2="HOURLY",1.5*C2,IF(B2="PT HOURLY",C2,IF(AND(B2="FT",C2<100000,c2*2,IF(AND(B2 ="FT",C2100000,C2<=1250000),C2*2.25,IF(AND(B2="FT ",C2125000,C2<175000),C2*2.4,IF(AND(B2="FT",C217 5000),C2*2.5))))))
what im trying to do is if B2=HOURLY then 1.5*C2 and if B2=PT HOURLY then 1*C2 and if B2=FT and C2<100000 then 2*C2 and if B2=FT and C2<100000 and =125000 then C2*2.25 and if B2=FT and C2<125000 and =175000 then C2*2.4 and if B2=FT and C2175000 then C2*2.5 |