Hil All
I have attached the file of data.
My problem is i have to find the qualifying month of sales by a formula.
if it does not qualify then it should reflect as "Not Qualify"
Pls Help!!
Regards,
Deepak
--
--
So
Dear deepak
here is the sample formula
=If(sum(b2:b2)>=100,"Qualified","Not Qualified")
--
*Great day,*
*viper*
On Fri, Sep 23, 2011 at 3:04 PM, Deepak Rawat wrote:
> Hil All
>
> I have attached the file of data.
>
> My problem is i have to find the qualifying month of sales by a formula
Hi Deepak,
Copy and paste the below formula in Second Row after Column H.
=IF(B2>100,B$1,IF(SUM(B2:C2)>100,C$1,IF(SUM(B2:D2)>100,D$1,IF(SUM(B2:E2)>100,E$1,IF(SUM(B2:F2)>100,F$1,IF(SUM(B2:G2)>100,G$1,IF(SUM(B2:H2)>100,H$1,"Not
Qualified")))
I have attached an example file for your better unde
quot;) = "Not Qualified"
Else
'MsgBox Cells(1, j - 1)
Cells(i, "K") = Cells(1, j)
Cells(i, j).Interior.ColorIndex = 4
Exit For
End If
Next j
Next i
End Sub
-Original Message-
From: Deepak Rawat
Sent: Friday, September 23, 2011 4:34 AM
To: excel-macros
Subject: $$Excel-Macr
