Re: understanding what part of a formula represents
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Wed, 08 Oct 2008 21:24:51 -0500
First, there was an extra closing paren in your formula. It should have read:
=IF(COUNTIF($F$2:$F$20,B2)>=1,"remains on report","fell off report")
And >= is the symbol for "greater than or equal to"
So if the number of times the value in B2 shows up in F2:F20 is greater than or
equal to 1 (it appears at least one time), then return "remains on report". If
the value is 0 (it doesn't appear), then show "fell off report.
I think I would have used:
=IF(COUNTIF($F$2:$F$20,B2)>0,"remains on report","fell off report")
But that's probably more of a personal preference.
Mrs Luke wrote:
I have numbers in column F and I want to see if they are duplicated anywhere
in column B. I was given a formula that seems to work but I do not
understand part of the formula. The part I want to know what is represents
is >=1
The formula is as follows:
=IF(COUNTIF($F$2:$F$20),B2)>=1,"remains on report","fell off report")
What does greater then or equal to 1 mean?
--
mrs luke
--
Dave Peterson
.
- References:
- understanding what part of a formula represents
- From: Mrs Luke
- understanding what part of a formula represents
- Prev by Date: Re: problem with excel logic, too complicated of a function set???
- Next by Date: Help with Nested IF/And Function
- Previous by thread: understanding what part of a formula represents
- Next by thread: Re: understanding what part of a formula represents
- Index(es):
Relevant Pages
|
