LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
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 01:19 AM.

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

About Us

"It's about Microsoft Excel"