=IF(C12="","",IF(C12<>C10,IF(LEFT(C12,2)=47,47,"")))
I know that the "LEFT" function is text based, but it was a last ditch effort to get this to work.
Basically it starts by checking to see if c12 is filled or not...works fine. Then it goes on to see if c12 is different from c10 and if it is, is it filled with a 5 digit number starting with 47? If it is then the cell that this formula is nested in will, rather, should put a 47 in it and if there is not then the cell should remain blank or empty.
Any suggestions?
I know that the "LEFT" function is text based, but it was a last ditch effort to get this to work.
Basically it starts by checking to see if c12 is filled or not...works fine. Then it goes on to see if c12 is different from c10 and if it is, is it filled with a 5 digit number starting with 47? If it is then the cell that this formula is nested in will, rather, should put a 47 in it and if there is not then the cell should remain blank or empty.
Any suggestions?