Forum Discussion
number 99 fails in my formula, here is the formula I need to where it works with "F" but not "99"?
This is a formula I am using currently but I need to change the code "F" to what we are using in our accounting ledger "99". I thought I could simply change the "F" into new code "99" but it doesn't ...
Hi, I tried this formula which changed an F instance into 99 in the appropriate cell which worked but are you after something different? =IF(A6="F","99","")
You may wish to consider using a SUBSTITUTE formula to make content changes... =SUBSTITUTE(A6,"F","99")