| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Functions - IF?
if B1-B5 are EXCL and B6-B10 are not is there a way to show that. I
tried the formula putting B1:B5 but it did not work - can you tell me what I am doing wrong? This is how I entered the formula: =IF(B1:B5="EXCL",A1:A5*-1,0) Maybe this would help: =IF(AND( COUNTIF(B1:B5,"EXCL")=5, COUNTIF(B6:B10,"EXCL")=0), A5*-1, 0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
![MyVeryOwnSelf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
