Excel If/Then's
On Mar 8, 9:25 am, Dave F wrote:
Here's a more efficient version: =IF(--(NOT(ISBLANK(A1:C1))),"remove","don't
remove")
Or if you want to test for numbers: =IF(--(ISNUMBER(A1:C1)),"remove","don't
remove")
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"Dave F" wrote:
Assume the three cells in question are A1, B1, and C1. Then
=IF(NOT(OR(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1)))," remove","don't remove")
will return "remove" only if each of A1, B1, and C1 are populated.
Alternatively, if you want to test for the presence of numbers (as opposed to
any value), use this modification:
=IF(OR(ISNUMBER(A1),ISNUMBER(B1),ISNUMBER(C1)),"re move","don't remove")
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
what does the -- represent? Just for my clarifiacation?
" wrote:
I have three columns that will be populated with a positive, a
negative or the number zero. How do I populate a fourth column with
"remove" once the three previous columns have been filled with
something? I know I probably can use an if then statement but I am
not for sure what the text will be since the numbers can be pos, neg,
or equal?
Brandon Galindo- Hide quoted text -
- Show quoted text -
|