![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Stockton, California
Posts: 281
|
just a general question:
I variables A, B, and C. I want to test if they are >0. I would like to return ALL that are greater than 0. There is a total of 8 situations that could be returned: None, A, AB, AC, B, BC, C,or All (CB would count as BC) My question is: Is it more correct or easy (it doesnt seem so) to make a nested IF statement, or use a Case statement? or is it a matter of taste? Ive tried writing a nested IF, but its gotten very messy |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Northern Ireland
Posts: 113
|
Hi there
Most people I know would use case statements. Better readability I guess. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|