Re: understanding what part of a formula represents

Tech-Archive recommends: Fix windows errors by optimizing your registry

COUNTIF($F$2:$F$20,B2) will return the count of the criteria in the
referenced range. The criteria is B2 and the referenced range is F2:F20.

This count is being used as the logical test in the IF function. In plain
English:

If the count of B2 in the range F2:F20 is greater than or equal to 1 then
return the string "remains on report" otherwise return the string "fell off
report".

This can also be expressed as

=IF(COUNTIF($F$2:$F$20,B2),"remains on report","fell off report")

If the count is any number other than 0 then the logical test is TRUE and
returns the string "remains on report". If the count is 0 then the logical
test is FALSE and returns the string "fell off report".

--
Biff
Microsoft Excel MVP


"Mrs Luke" <mrsluke@xxxxxxxx> wrote in message
news:4CB799FB-E619-4071-8BB3-654C5F1DF7D0@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... What I need it to do is also filter in the date report using the clients name ... here is an example that tests criteria and builds a filter string to use ...
    (microsoft.public.access.forms)
  • Re: Running 2 reports in a form together
    ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ... Since a filter is applied on the recordset, they do not have to be on the report object ...
    (microsoft.public.access.forms)
  • Re: QBF search criteria to report
    ... There are a couple of different ways that QBF forms typically work: ... You leave the criteria out of the query, and build a Filter string to ... description to the report, and display it there. ...
    (comp.databases.ms-access)
  • Re: Reports-Multi-Select List Box
    ... several orders from the listbox and print them. ... You don't need to build up a criteria ... > string; you need to OpenReport for each one. ... >> 'Open Report ...
    (microsoft.public.access.formscoding)