If Function?

K

KATYDID

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

I've been trying to use this formula, but it doesn't appear that IF ca
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
 
D

David Biddulph

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.
 
K

KATYDID

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

KATYDID

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