View Single Post
  #49  
Old 21st May 2009, 02:03 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,408
Default

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 ","
Reply With Quote