If condition to find Target

  • Thread starter Thread starter Karthik
  • Start date Start date
K

Karthik

I've a data(#of products sold in a day) in Column 'D' to 'L', I am trying to
find out the sales target achieved by each Employee. Targets are given in
column P. If none of the items are sold then i want it to display "none"

D E F G H I J K L

3 4 1 10 1 1 1 1

I tried get the result with this formula, but it goes wrong somewhere.
=IF(SUM(D7:L7)=0,"None",(IF(AND(D7>=$P$4,E7>=$P$5,F7>=$P$6,G7>=$P$7,H7>=$P$8,I7>=$P$9,J7>=$P$10,K7>=$P$11,),"Achieved",IF(OR((D7<$P$4)*(D7>0),(E7<$P$5)*(E7>0),(F7<$P$6)*(F7>0),(G7<$P$7)*(G7>0),(H7<$P$8)*(H7=0),(I7<$P$9)*(I7>0),(J7<$P$10)*(J7>0),(K7<$P$11)*(K7>0),),"NOT Achieved","Achieved"))))

I've more than 360 rows of data, could any please let me know where I've
gone wrong or if there's any other way to get the desired result

Thanks and regards
 
Hi

I am confused by your formula

Assuming you want to return the following based on the condition
"Achieve" when the sum in D2 to L2 of one employee hit or exceed the target
set in col P
starting from P2
"Not Achieved" when the sum in D2 to L2 is less than P2
"None" when D2 to L2 is blank

try this
=IF(SUM(D2:L2)>=P2,"Achieve",IF(SUM(D2:L2)=0,"None","not achieve"))
does this do what 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
 
Hi

I am confused by your formula

Assuming you want to return the following based on the condition
"Achieve" when the sum in D2 to L2 of one employee hit or exceed the target
set in col P
starting from P2
"Not Achieved" when the sum in D2 to L2 is less than P2
"None" when D2 to L2 is blank

try this
=IF(SUM(D2:L2)>=P2,"Achieve",IF(SUM(D2:L2)=0,"None","not achieve"))
does this do what 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
 
Back
Top