the "OR" question:you're actually most of the way there with your logic, just
stating the question!
In an IF() statement, the first part is the "logical test", followed by what
happens if the test is "true" and what happens if the test is "false".
The "logical test" can be anything that results
If you REALLY want to shorten your formula:
the =concatenate() function is a "throwback" to earlier versions of excel and
only included for "backward compatibility".
"technically", these two are the same
thing:=CONCATENATE("AB",TEXT(I2,"0"))="AB" & TEXT(I2,"0")
Hi Karthik!
Thanks for the reply!
I liked the use of the LEN & AND statements, but your formula seemed longer
than mine.
So I looked at yours again and realized I could ALSO use:
'=IF(Len(I2)<=5,CONCATENATE("AB",TEXT(I2,"0")),I2)
Now granted, it does allow for accidental numbers, like
Paul,
OK, there are several things going on here.(and my email is grouping SOME of
them as one conversation, but separating others as if it's a different
discussion)
Some of your statements are confusing.Partially because some terms you're using
have very specific meanings that you may be
Okay, after a bit of research, I've gotten a sort of formula:
=IF((A1)>10,(A1),(CONCATENATE("AB",(TEXT(A1,"0")
This actually does what I wanted. However, I'd still like to have the final
number be just a literal number, not a formula.
Assuming A1 is the original number and B1 is
Okay, after a bit of research, I've gotten a sort of formula:
=IF((A1)>10,(A1),(CONCATENATE("AB",(TEXT(A1,"0")
This actually does what I wanted. However, I'd still like to have the final
number be just a literal number, not a formula.
Assuming A1 is the original number and B1 is
Guess, I could add that I've used:
Concatenate ("",A1) to give me all my zeros.
Right (A2,5) function, to reduce the number to just the five digits, or six
to give me six digits.
Then I've used Concatenate ("AB",A1) which will give me all of these
numbers, EXCEPT the six digit ones.
I can't