[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Calc 18.104.22.168 IF criteria statement help
- Subject: Re: [libreoffice-users] Calc 22.214.171.124 IF criteria statement help
- From: Remy Gauthier <firstname.lastname@example.org>
- Date: Sat, 10 Nov 2018 10:55:48 -0500
- To: Michael H <email@example.com>, firstname.lastname@example.org, email@example.com
I believe you had a similar (if not identical question) which you
posted back on September 27th (topic: IF doesn't respect AND - http://d
respect-AND-td4249584.html). At the time you had uploaded a file to
Google and I had offered a possible solution to your problem which had
worked in my environment. I am curious to know if you have tried it and
if it worked.
Le samedi 10 novembre 2018 à 08:16 -0600, Michael H a écrit :
> I'm not sure I follow your logic, but if your source range contains a
> of values that includes nulls, and non-numbers, you need to logically
> exclude those from a math statement, or you get the 'VALUE' error
> (tried to
> do math on a non-numeric cell.) ISBLANK, and ISNUMBER are functions
> provide the way around the VALUE.
> If you're trying to make a list of values out of a column of values,
> investigate CONCATENATE. The problem with concatenate is that it
> auto-insert separators and whitespace. You'll either need to include
> a new
> column with ", " in each row and concatenate 2 columns, or have the
> appropriate whitespace in each cell.
> If you only have a couple cells to concatenate, you can be precise
> with the
> & operator. that is [="Hello "&"there!"] allows multiple strings in
> single cell, and each string can be cell references or functions with
> string or numeric output. [="I've seen "&A5&", "&G3&" cells today."]
> is a
> nice way to summarize your data in human readable form.
> If you're trying to only pick a few values, investigate LOOKUP. I'm
> excel refugee, (and used Lotus, and 8bit (GEOS) spreadsheets before
> LibreOffice version of LOOKUP is.... not very well done, but if
> patient with it, it gets the job done. I frequently have to insert
> rows containing null cells when I want 'exact match only', and
> can't deal with 'non-sorted' indexes, and they aren't clearly or
> what the sorting pattern should be, so it's best to sort your data
> LibreOffice before you use lookup. (for lookups, a ==A or not,
> NBSP == space, but sometimes not. This affects matches, but also
> and sort failures breaks many responses, not just one. These sorting
> issues are constant for a single edition of libreoffice, but seem to
> without any notice on updates.)
> On Sat, Nov 10, 2018 at 7:44 AM Hylton Conacher (ZR1HPC) <
> firstname.lastname@example.org> wrote:
> > Hi,
> > What I need help with is the formula to find any row from Data.$A$3
> > to
> > Data$A$1000 and after shortening the 8 digit date value to 6 digit
> > value, and having the same 6 digit value as Summary.$A4, forward
> > ONLY
> > those rows onto the next part of the formula i.e. SUMIF.
> > I have a formula shown below but currently is showing me #VALUE! as
> > my
> > result.
> > "=IF(INT(Data.$A$31:Data.$A$50/100)=Summary.$A4,SUMIF(Data.$F$31:Da
> > ta.$F$50,"N",Data.$C$31:Data.$C$50))"
> > I have identified the problem where the INT value = Summary.$A4
> > What would the correct syntax be to have a criteria equal a
> > specified
> > value as a criteria in a formula? I tried encasing
> > "INT...=Summary.A4",
> > but no luck.
> > SUMIFS does not assist as the criteria to find, after INT
> > shortening
> > must equal another value before the next step can be carried out.
> > Appreciate any help. Where should I upload a file Nabble, GDrive,
> > other?
> > Regards
> > Hylton
> > --
> > To unsubscribe e-mail to: email@example.com
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri
> > be/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Neti
> > quette
> > List archive: https://listarchives.libreoffice.org/global/users/
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|Re: [libreoffice-users] Calc 126.96.36.199 IF criteria statement help||"Hylton Conacher (ZR1HPC)" <email@example.com>|
|[libreoffice-users] Calc 188.8.131.52 IF criteria statement help||"Hylton Conacher (ZR1HPC)" <firstname.lastname@example.org>|
|Re: [libreoffice-users] Calc 184.108.40.206 IF criteria statement help||Michael H <email@example.com>|
- Prev by Date: Re: [libreoffice-users] Calc 220.127.116.11 IF criteria statement help
- Next by Date: [libreoffice-users] Templates not linked in Writer after update to Xubuntu 18.04
- Previous by thread: Re: [libreoffice-users] Calc 18.104.22.168 IF criteria statement help
- Next by thread: Re: [libreoffice-users] Calc 22.214.171.124 IF criteria statement help