Less than/ Greater than logic flipped.
 

060327: Less than/ Greater than logic flipped. thanks in advance. hope not
too much detail,
---------------- original info:
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over each
other, no change...)
----------------
for PROCEDU (result is either formula works without proc, or cond.
formatting works with formula, and cond. formatting does not)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto EditCopy, select destination cell; EditPaste SpecialAdd

(is proc good?) DOES PREFORMATTING / DEFAULT FORMATTING Include hi-liting
whole column? Does that Negate any signle cell changes to default to what
column is??

what is the add doing (addition?)
if that is for formatting.. how should I set up my equation, in the first
place:
example here, don't worry about what is doing besides converting to a format
to read either: "0.00" or "#,##0"

is there a way to get those choices, without having cell treated as text?
as it stands, doing PROCEDURE the top line below (IF(OR etc true, then ""
nothing, does not function), but peculiar: adds to equation =(IF.... )+0

OTHERWISE: formula works, but cond. formatting does not recognize as
numbers?? Would that be the answer: to get cond. format to have isnumber(
added? (could not get that to work)

(merely chooses between 1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9="",BD9="",CB9=""),AND(BC9="",OR($BT $2="fm",EXACT(F9,"B")))),"",IF($BT$5=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))/1000),2),"0.00"),TEXT((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))), "#,##0")))

Less than/ Greater than logic flipped.
 

Check the format, you probably have text formats involved


--

Regards,

Peo Sjoblom


"nastech" wrote in message
...
060327: Less than/ Greater than logic flipped. thanks in advance. hope
not
too much detail,
---------------- original info:
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over
each
other, no change...)
----------------
for PROCEDU (result is either formula works without proc, or cond.
formatting works with formula, and cond. formatting does not)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto EditCopy, select destination cell; EditPaste SpecialAdd

(is proc good?) DOES PREFORMATTING / DEFAULT FORMATTING Include hi-liting
whole column? Does that Negate any signle cell changes to default to what
column is??

what is the add doing (addition?)
if that is for formatting.. how should I set up my equation, in the first
place:
example here, don't worry about what is doing besides converting to a
format
to read either: "0.00" or "#,##0"

is there a way to get those choices, without having cell treated as text?
as it stands, doing PROCEDURE the top line below (IF(OR etc true, then ""
nothing, does not function), but peculiar: adds to equation =(IF.... )+0

OTHERWISE: formula works, but cond. formatting does not recognize as
numbers?? Would that be the answer: to get cond. format to have
isnumber(
added? (could not get that to work)

(merely chooses between 1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9="",BD9="",CB9=""),AND(BC9="",OR($BT $2="fm",EXACT(F9,"B")))),"",IF($BT$5=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))/1000),2),"0.00"),TEXT((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))), "#,##0")))

Less than/ Greater than logic flipped.
 

even if formated as a number. one may be text.
try
=value(u14)<value(u15)

"nastech" wrote:

060327: Less than/ Greater than logic flipped. thanks in advance. hope not
too much detail,
---------------- original info:
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over each
other, no change...)
----------------
for PROCEDU (result is either formula works without proc, or cond.
formatting works with formula, and cond. formatting does not)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto EditCopy, select destination cell; EditPaste SpecialAdd

(is proc good?) DOES PREFORMATTING / DEFAULT FORMATTING Include hi-liting
whole column? Does that Negate any signle cell changes to default to what
column is??

what is the add doing (addition?)
if that is for formatting.. how should I set up my equation, in the first
place:
example here, don't worry about what is doing besides converting to a format
to read either: "0.00" or "#,##0"

is there a way to get those choices, without having cell treated as text?
as it stands, doing PROCEDURE the top line below (IF(OR etc true, then ""
nothing, does not function), but peculiar: adds to equation =(IF.... )+0

OTHERWISE: formula works, but cond. formatting does not recognize as
numbers?? Would that be the answer: to get cond. format to have isnumber(
added? (could not get that to work)

(merely chooses between 1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9="",BD9="",CB9=""),AND(BC9="",OR($BT $2="fm",EXACT(F9,"B")))),"",IF($BT$5=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))/1000),2),"0.00"),TEXT((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))), "#,##0")))

Less than/ Greater than logic flipped.
 

Hi, would seem I didn't include enough info.. previous question/ reponse was
advised maybe: istex() isnumber(), but seems value() is doing the trick..
thanks for the help..

"Peo Sjoblom" wrote:

Check the format, you probably have text formats involved


--

Regards,

Peo Sjoblom


"nastech" wrote in message
...
060327: Less than/ Greater than logic flipped. thanks in advance. hope
not
too much detail,
---------------- original info:
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over
each
other, no change...)
----------------
for PROCEDU (result is either formula works without proc, or cond.
formatting works with formula, and cond. formatting does not)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto EditCopy, select destination cell; EditPaste SpecialAdd

(is proc good?) DOES PREFORMATTING / DEFAULT FORMATTING Include hi-liting
whole column? Does that Negate any signle cell changes to default to what
column is??

what is the add doing (addition?)
if that is for formatting.. how should I set up my equation, in the first
place:
example here, don't worry about what is doing besides converting to a
format
to read either: "0.00" or "#,##0"

is there a way to get those choices, without having cell treated as text?
as it stands, doing PROCEDURE the top line below (IF(OR etc true, then ""
nothing, does not function), but peculiar: adds to equation =(IF.... )+0

OTHERWISE: formula works, but cond. formatting does not recognize as
numbers?? Would that be the answer: to get cond. format to have
isnumber(
added? (could not get that to work)

(merely chooses between 1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9="",BD9="",CB9=""),AND(BC9="",OR($BT $2="fm",EXACT(F9,"B")))),"",IF($BT$5=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))/1000),2),"0.00"),TEXT((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))), "#,##0")))

Less than/ Greater than logic flipped.
 

at first glance things seem to be working, thank you!!
had tried: istext() isnumber(), but value() seems to do the trick.

"bj" wrote:

even if formated as a number. one may be text.
try
=value(u14)<value(u15)

"nastech" wrote:

060327: Less than/ Greater than logic flipped. thanks in advance. hope not
too much detail,
---------------- original info:
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over each
other, no change...)
----------------
for PROCEDU (result is either formula works without proc, or cond.
formatting works with formula, and cond. formatting does not)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto EditCopy, select destination cell; EditPaste SpecialAdd

(is proc good?) DOES PREFORMATTING / DEFAULT FORMATTING Include hi-liting
whole column? Does that Negate any signle cell changes to default to what
column is??

what is the add doing (addition?)
if that is for formatting.. how should I set up my equation, in the first
place:
example here, don't worry about what is doing besides converting to a format
to read either: "0.00" or "#,##0"

is there a way to get those choices, without having cell treated as text?
as it stands, doing PROCEDURE the top line below (IF(OR etc true, then ""
nothing, does not function), but peculiar: adds to equation =(IF.... )+0

OTHERWISE: formula works, but cond. formatting does not recognize as
numbers?? Would that be the answer: to get cond. format to have isnumber(
added? (could not get that to work)

(merely chooses between 1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9="",BD9="",CB9=""),AND(BC9="",OR($BT $2="fm",EXACT(F9,"B")))),"",IF($BT$5=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))/1000),2),"0.00"),TEXT((

$BT$5/IF(OR($BT$2="fm",EXACT(F9,"B"),AND(BC9<"",BD9="") ),BC9,IF(BD9<"",BD9,IF(OR(CB9={"",0}),"",CB9)))), "#,##0")))