| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
=IF(A3:A200=(TRIM("Total Revenue:")),B3:B200,0)
If the text Total Revenue appears in A19, I would like Excel to return the corresponding data in B19. If not, then return 0. What am I doing wrong? I have looked throughout this site and am not finding my answer so if it has been answered before, please point me to the correct place. My apologies/thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
