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