View Single Post
  #1   Report Post  
gusjen gusjen is offline
Junior Member
 
Posts: 1
Default 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