LinkBack URL
About LinkBacks
Where is the 2 coming from exactly? What do you mean there is a quantity for "unit"?
If you simply want a 2 for every cell with Unit and 0 if no unit in the cell..then:
=2*isnumber(Search("Unit",A2))
Where is the 2 coming from exactly? What do you mean there is a quantity for "unit"?
If you simply want a 2 for every cell with Unit and 0 if no unit in the cell..then:
=2*isnumber(Search("Unit",A2))
Last edited by NBVC; 03-10-2011 at 04:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks