|
|
 |
| found 50 articles for 0.302 sec |
  |
| On Sep 3, 10:54 am, Pranav Vaidya
<PranavVai...@discussions.microsoft.com> wrote:
> Hi,
>
> You can have these many conditions.
>
> =IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1=0),A1<=5),B1<=5),"YELLOW",""))
>
> You may need to twick this as I have not completely tested this. It would
> have been a lot easier with some sample data.
> HTH,
> --
> Pranav Vaidya
|
|
 |
|
 |
Group: microsoft.public.excel.misc · Group Profile · Search for Twicked in microsoft.public.excel.misc
Author: jesoldano
Date: Sep 3, 2008 08:25
On Sep 3, 10:54 am, Pranav Vaidya <PranavVai...@discussions.microsoft.com> wrote: Hi, You can have these many conditions. =IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1=0),A1<=5),B1<=5),"YELLOW","")) You may need to twick this as I have not completely tested this. It would have been a lot easier with some sample data. HTH, -- Pranav Vaidya
|
| Show full article (1.09Kb) · Show article thread |
| Hi,
You can have these many conditions.
=IF(AND(A1>=5,B1>2),"RED",IF(AND(A1<=5,B1=0),"GREEN",IF(AND(OR(AND(A1>=5,B1=0),A1<=5),B1<=5),"YELLOW",""))
You may need to twick this as I have not completely tested this. It would
have been a lot easier with some sample data.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think a post is useful, please rate it as an ANSWER, it will |
|
|
|
|
Group: microsoft.public.excel.misc · Group Profile · Search for Twicked in microsoft.public.excel.misc
Author: jesoldano
Date: Sep 3, 2008 08:20
I twicked the code a bit :) The select expressions can be merged into one, and to avoid $null objects down the pipline (and the if() statment), Get-ChildItem's results are piped to where. One thing to bear in mind: spaces in a column header names (e.g. calculated property), it can get you into *trouble* :) $path = "C:\temp" $homedirs = Get-ChildItem $path | where {$_.PSIsContainer
|
| Show full article (1.33Kb) · Show article thread |
|
|
|
1 ·
2 ·
3 ·
4 ·
5 ·
next |
|
|
