| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
