Reference left most value in cell
 

How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true statement,
false statement)
Ex: A1= <45
I want function to locate "<"

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1

Reference left most value in cell
 

=IF(Left(A1,1)=Left(B1,1),"True","False")
--
Always provide your feedback...


"rtwiss via OfficeKB.com" wrote:

How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true statement,
false statement)
Ex: A1= <45
I want function to locate "<"

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1

Reference left most value in cell
 

What do you mean by "left most cell value in A1" ?
A cell has only ONE value
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"rtwiss via OfficeKB.com" <u46610@uwe wrote in message
news:8bc502ce4852b@uwe...
How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true
statement,
false statement)
Ex: A1= <45
I want function to locate "<"

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1

Reference left most value in cell
 

Simplify version:

=LEFT(A1)=LEFT(B1)


"Sheeloo" wrote:

=IF(Left(A1,1)=Left(B1,1),"True","False")
--
Always provide your feedback...


"rtwiss via OfficeKB.com" wrote:

How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true statement,
false statement)
Ex: A1= <45
I want function to locate "<"

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1