Hi yogi,
Can use this formula too...
=IF(SUM(--(A1:D1>5))>=2,"Good","Poor")
(apply with Ctrl + Shift + Enter)
Regards,
MARIES.
On Mon, Dec 12, 2011 at 7:00 PM, rajan verma wrote:
> See the attached File..
>
>
> On Wed, Nov 30, 2011 at 8:39 PM, Sam Mathai Chacko wrote:
>
>> This formula would
Dear Yogi,
You can also try through UDF Nested_If
*Function Nested_if(rng As Range)
counter = 1
For Each cell In rng
If cell.Value > 5 Then
counter = counter + 1
End If
Next
If counter > 2 Then
Nested_if = "Good"
Else
Nested_if = "Poor"
End If**
End Function
*
On Sat, Dec 10, 2011 at 4
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 8:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting formula
thankq very much
On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 wrote
011 4:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help for If nesting formula
>
> HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
>
> Q1) i have four months
>
> jan feb marapr
>
> 61 5 0
>
=IF(COUNTIF(A3:D3,">5")>1,"good","bad")
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 4:59 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting for
Hi,
Can you explain more or send us the sample.
Regards,
MARIES.
On Sat, Dec 10, 2011 at 2:59 PM, yogiyogi123 wrote:
> HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
>
> Q1) i have four months
>
> jan feb marapr
>
> 61 5 0
>
> if any two month get
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
Q1) i have four months
jan feb marapr
61 5 0
if any two month get '> 5' then the result is GOOD other wise POOR . KINDLY
RECTIFY THIS PROBLEM.
THANK Q
--
FORUM RULES (934+ members already BANNED for v
Hi,
Try also without any tables,
=LOOKUP(A2,DATE(YEAR(TODAY()),-{1342,35,12,9,6,3}+MONTH(TODAY()),0),{"Prospect";">
12 Month";"9 - 12 Month";"6 - 9 Month";"3 - 6 Month";"0 - 3 month"})
Or, if you activate Analysis ToolPak AddIn (unless if you are using XL2007
or later), you can simplify,
=LO
Thanx to all my team member and Noorain.
On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI
wrote:
> Dear Lucky,
>
> Please paste below formula in B2 Cell.
>
> =IF(AND(A2>=$F$2,A2<=$G$2),"0-3 Month",IF(AND(A2>=$F$3,A2<=$G$3),"3-6
> Month",IF(AND(A2>=$F$4,A2<=$G$4),"6-9
> Month",IF(AND(A2>=$F$5,A2<
Hi Singh,
Would you explain the logic for the file? If 1 value is bigger than another
1, you would like the cell to return something, am i right??
Darwin
2011/11/30 lucky singh
>
> Hello Team,
>
>
> Require your help for If nesting formula please see the attachment.
>
>
> Regards,
> Lucky
>
>
Dear Lucky,
Please paste below formula in B2 Cell.
=IF(AND(A2>=$F$2,A2<=$G$2),"0-3 Month",IF(AND(A2>=$F$3,A2<=$G$3),"3-6
Month",IF(AND(A2>=$F$4,A2<=$G$4),"6-9
Month",IF(AND(A2>=$F$5,A2<=$G$5),"9-12
Month",IF(AND(A2>=$F$6,A2<=$G$6),">12 Month","Prospect")
On Wed, Nov 30, 2011 at 12:09 PM, luc
11 matches
Mail list logo
