I'm trying to achieve a function that will read down column A, note each
time a text string occurs, then perform an operation on a value in
column C, same row.

I've been trying to use this formula, but it doesn't appear that IF can
work down a column in this way.

=IF(A2:A1000="test", C2/5, "NOT BILLED FOR test THIS MONTH")

Is there another (relatively easy) way to do this?

Thanks!


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in

Try:

=IF(COUNTIF(A1:A1000,"Test"),C2/5,"NOT BILLED FOR test THIS MONTH")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"KATYDID" wrote in message
...

I'm trying to achieve a function that will read down column A, note each
time a text string occurs, then perform an operation on a value in
column C, same row.

I've been trying to use this formula, but it doesn't appear that IF can
work down a column in this way.

=IF(A2:A1000="test", C2/5, "NOT BILLED FOR test THIS MONTH")

Is there another (relatively easy) way to do this?

Thanks!


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in

If you want to perform the operation in that row only if "test" occurs as
the column A value in that row, then use
=IF(A2="test", C2/5, "NOT BILLED FOR test THIS MONTH") in row 2, and copy
the formula down the other rows.
--
David Biddulph

"KATYDID" wrote in message
...

I'm trying to achieve a function that will read down column A, note each
time a text string occurs, then perform an operation on a value in
column C, same row.

I've been trying to use this formula, but it doesn't appear that IF can
work down a column in this way.

=IF(A2:A1000="test", C2/5, "NOT BILLED FOR test THIS MONTH")

Is there another (relatively easy) way to do this?

Thanks! When I try Sandy's suggestion, it stops at the first row in the
column. I'm actually trying to search down a column of text for the
'test' value, and operate on numeric values in the same row, different
column. I want to do this on multiple 'test' values, so i don't want
to put the formula on each row, but if that is what I have to do - is
there a way to test for multiple 'test' values within the one forumula?


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in

I got the 'search on multiple if statements' thing down, but it's really
inefficient. Is there something I'm missing? Maybe arrays?


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in

"KATYDID" wrote in message
...

Thanks! When I try Sandy's suggestion, it stops at the first row in the
column.

That's because Sandy Mann can't read <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"KATYDID" wrote in message
...

Thanks! When I try Sandy's suggestion, it stops at the first row in the
column. I'm actually trying to search down a column of text for the
'test' value, and operate on numeric values in the same row, different
column. I want to do this on multiple 'test' values, so i don't want
to put the formula on each row, but if that is what I have to do - is
there a way to test for multiple 'test' values within the one forumula?


--
KATYDID
------------------------------------------------------------------------
KATYDID's Profile: http://www.officehelp.in/member.php?userid=5993
View this thread: http://www.officehelp.in/showthread.php?t=1318937

Posted from - http://www.officehelp.in