At 20:31 29/07/2014 -0700, Joe Conner wrote:
Did you try inserting quots which will become
=IF(H44=AUG,Paid.D21,) perhaps?
I hope he didn't, as then he'd get the text Paid.D21 itself as the
formula result, instead of a copy of cell D21 from the sheet named
Paid - which is presumably what he
Hi All
I'm using a lot of IF functions in my Spreadsheets to limit DIV and NAME
errors with rows that don't have values in them yet.
I came across a situation today where I need to test text - ie I need to
test for a month's name.
I tried =IF(Cell Ref=AUG,do calculation.)
But this gives
Hi,
Le 29/07/2014 17:43, Ian Whitfield a écrit :
I came across a situation today where I need to test text - ie I need to
test for a month's name.
If the referenced cell (say it's A1) contains a month name :
=IF(A1=AUG;doYes;doNo)
If the referenced cell contains a date formatted to display
At 17:43 29/07/2014 +0200, Ian Whitfield wrote:
I'm using a lot of IF functions in my Spreadsheets to limit DIV and
NAME errors with rows that don't have values in them yet. I came
across a situation today where I need to test text - ie I need to
test for a month's name. I tried =IF(Cell
On 07/29/2014 10:45 PM, Brian Barker wrote:
The only thing wrong with your example is the dot separating the
second and third arguments - which presumably should be a comma. There
is nothing in the basic structure you are illustrating here that would
stimulate a #NAME? error, so the problem
Another off-the-top-of-my-head stab at the problem, but in a pull down
list, doesn't the cell maybe actually store the index of the list, so
assuming JAN is the first item in the list, AUG should be either
the 7th (zero-based list) or the 8th (1 based list) entry, so try:
=IF(H44=7,Paid.D21,)
or
I think I've tracked down the problem but not the answer
My full statement is - =IF(H44=AUG,Paid.D21,)
Paid.D21 is the value I want to insert if the month is correct.
H44 contains the month, ie AUG - and this seems to be the problem.
It is a pull-down list of months. If I enter the month
On 07/29/2014 17:06, Brian Barker wrote:
I think I've tracked down the problem but not the answer
My full statement is - =IF(H44=AUG,Paid.D21,)
Paid.D21 is the value I want to insert if the month is correct.
H44 contains the month, ie AUG - and this seems to be the problem. It
is a