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 ...
Thank you Riny, I will try that. It was someone else's template I am changing so unfortunately there are lot of cells I am not sure of the format and why they added certain formula functions. I am learning from this feedback so thank you again!
Cynde
Cynde
Agreed with Riny. Depends if you want a value (if false) or the cell left blank, if the latter then =IF(E17=99,C17,"")
- If you wanted to convert any code instances (99) to text then you always create a new column and use the formula =TEXT(E17,"00") which would then convert all numbers into two digit text values for further analysis.