Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with this formula
im needing an AND and OR function to get this to work right. i have it
working almost but it is not showing any 0 answers. im sure the OR functionj is medded up. if =IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]=1),5,IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]<1),3,IF(OR(Leave[[#This Row],[Status]]="PT", Leave[[#This Row],[Years Employed]]1.5),3,0))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with this formula
Hi
would you post a sample of your data and the result you want -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "AET" wrote: im needing an AND and OR function to get this to work right. i have it working almost but it is not showing any 0 answers. im sure the OR functionj is medded up. if =IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]=1),5,IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]<1),3,IF(OR(Leave[[#This Row],[Status]]="PT", Leave[[#This Row],[Years Employed]]1.5),3,0))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with this formula
You are right...
Change the OR to AND With what you have ALL with Status = "PT" will get 3 also ALL with Years Emplyed 1.5 will get 3 "AET" wrote: im needing an AND and OR function to get this to work right. i have it working almost but it is not showing any 0 answers. im sure the OR functionj is medded up. if =IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]=1),5,IF(AND(Leave[[#This Row],[Status]]="FT",Leave[[#This Row],[Years Employed]]<1),3,IF(OR(Leave[[#This Row],[Status]]="PT", Leave[[#This Row],[Years Employed]]1.5),3,0))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|