Thread: IF Statment
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Momo Momo is offline
external usenet poster
 
Posts: 45
Default IF Statment

I am stuck with the IF statement under 3 different senarios. Please HELP!

A1=Y
B1=Director or Manager or Worker
C1=2 or 1.5 or 1
D1=year of service

If A1=Y and he is Director, he will get 2 weeks pay (C1) times D1 and cap at
12 years (24 weeks). But if A1=Y and he is a Manager, he will get 1.5 weeks
pay (C1) times D1 and cap at 12 years (18 weeks). But if A1=Y and he is a
Worker, he will get 1 week pay (C1) times (D1). How do I put all 3 IF
together?

It should be something like =IF(AND(A1="Y",B1="Director" and
D1<12),C1*D1,24; and so on. But don't know how to link all 3 together.