LinkBack URL
About LinkBacks
another approach I think is
another approach is
=IF(COUNTIF(A1:A5,1)>0,1,2)
or
=if(count(A1:A5)>0,1,2)
don't know how to write it in your language.
another approach I think is
another approach is
=IF(COUNTIF(A1:A5,1)>0,1,2)
or
=if(count(A1:A5)>0,1,2)
don't know how to write it in your language.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
It's not correct...it leaves 2 if there isn't numbers in 5 cellsOriginally Posted by vlady
another approach I think is
another approach is
=IF(COUNTIF(A1:A5,1)>0,1,2)
or
=if(count(A1:A5)>0,1,2)
don't know how to write it in your language.
I want empty space if no numbers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks