I am looking to search a column range for 99,88,77 within a cell, which are source identifiers, for example all cells with 0.0187099 and if 99 is found to replace with a 1 been getting results 0.018701 or 0.01870.100 when i just need a whole 1 or 1.00, the 99,88 etc. will always be at the end of the cell value
Assuming you're retaining the original returned data within a seperate column, this doesn't find the final 2 digits but it will find 99 within the cell value
simply adjust as required. Also further conditions (for 88 and 77 etc) can be added by expanding on the false return value like...
probably not the best formula but hope this gets you closer to what you're after
Assuming the data in the relevant column is in text format and that you want to convert each entry to 1 if and only if the entry ends in any one of 77, 88 and 99 (otherwise retaining the entry from the original column) then I think the following may suit:
Since the result seems to do little more than distinguish entries with or without source identifiers conditional formatting might be more direct, say using