![Old](images/statusicon/post_old.gif)
21st May 2009, 02:03 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,408
|
|
Need some help with this formula
=IF(BF7="","",IF(ISNUMBER(FIND(",",U7)),LEFT(U7,FIND(",",U7)-1),U7))
it checks to see if the cell is a number then it will remove eveything after "," problem is sometimes there is no bet fluctuation so there is just one set of numbers in the cell and it can't find "," so it returns nothing.
I need it to return the number in cell U7 if it can't find ","
|