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 ...
cynde1957 I suspect that the code 99 is entered as a number. check it by entering
=ISTEXT(E14) somewhere.
TRUE will tell you that it is a text, and you should indeed use "99" in the formula (i.e. with quote marks surrounding the digits 99).
FALSE means that it is not a text, but a number. Change the formula to
IF(E14=99, C14, 0)
By the way, no need to wrap it all in a SUM function.
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.
