Excel If/Then's
Hi
You could use
=COUNT(A1:C1)=3
This would return TRUE where there are numbers in all three columns, and
FALSE where there isn't
If you only wanted to show the True rows then
=IF(COUNT(A1:C1)=3,"Remove","")
--
Regards
Roger Govier
wrote in message
ps.com...
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
|