Good point - perhaps this is more of a database program query than suitable
for spreadsheets.
Thanks to both you and Claudia for your helpful and educational replies.
Kind regards, James.
----- Original Message -----
From: "Terry" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, October 18, 2006 2:47 PM
Subject: Re: [users] Calc formula question.?
I meant to add that any such formula is fallible because it will return "R"
if the amount looked up appears anywhere in the "amount" range. So, if you
have two or more bank payments which correspond to one expense, each will
be classified as "R".
If you want to use several conditions, you could look at SUMPRODUCT or a
database function such as DGET.
Terry wrote:
One possibility is IF(ISNUMBER(MATCH(<debit cell>;<expenses amount
column>;0);"R";"")
James Elliott wrote:
<snip>
What I want to achieve is this:
if there is an entry on my "Bank" statement sheet for, say, $7.55;
and an identical amount in "Expenses" (ie, also for $7.55);
then I want the letter "R" entered into the corresponding cell in the
"Reconciled" column of the "Bank" sheet.
<snip>
Many thanks, James
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.4/478 - Release Date: 17/10/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
