software

Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170lt;186,000 comes up TRUE

but when have in separate cells: 170 in U14 amp; 186000 in U15
=U14lt;U15 comes up FALSE

=U14gt;U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over each
other, no change...)Hi!

U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
to NUMBER.

Try this:

=ISTEXT(U14)
=ISNUMBER(U14)

Select an empty cell. Make sure this cell has not been preformatted and its
format is the default GENERAL.
Goto Editgt;Copy
Select cell U14
Goto Editgt;Paste Specialgt;Add
OK

Did that straighten things out?

Biff

quot;nastechquot; gt; wrote in message
news
gt; Hi, don't know what is wrong, small question?? ugh
gt; have equations involved, but simple version also shows as in same cell:
gt;
gt; 170lt;186,000 comes up TRUE
gt;
gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; =U14lt;U15 comes up FALSE
gt;
gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt;
gt; (right click all cells format: number, same each / paste formats over
gt; each
gt; other, no change...)
gt;
Thanks!! what is the add, step, doing? never would have got that. Seems
like that should not happen, or should be transparent for Text / Number
Status... (maybe good for a geez whats up list, would appear to have been a
prob for awhile).

Anyways it would seem to be technicallly different than what doing in a
major equation using. (example proofed to work, this example in cell BT9,
for quantity of shares to buy.. BT5 $-IN, bc bd cb are embedded inputs, but
Question is for the TEXT option used. Should I use an ISNUMBER instead or in
addition to? Else answer might be to use ISNumber in other equations that
refer to this cell.
please excuse long example:
DO I NEED TO CHANGE THIS EQUATION? (if recall, was given TEXT choices to
get formatting..) Thanks.

=IF(OR(AND(BC9=quot;quot;,BD9=quot;quot;,CB9=quot;quot;),AND(BC9=quot;quot;,OR($BT $2=quot;fmquot;,EXACT(F9,quot;Bquot;)))),quot;quot;,IF($BT$5gt;=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2=quot;fmquot;,EXACT(F9,quot;Bquot;),AND(BC9lt;gt;quot;quot;,BD9=quot;quot;) ),BC9,IF(BD9lt;gt;quot;quot;,BD9,IF(OR(CB9={quot;quot;,0}),quot;quot;,CB9)))/1000),2),quot;0.00quot;),TEXT((

$BT$5/IF(OR($BT$2=quot;fmquot;,EXACT(F9,quot;Bquot;),AND(BC9lt;gt;quot;quot;,BD9=quot;quot;) ),BC9,IF(BD9lt;gt;quot;quot;,BD9,IF(OR(CB9={quot;quot;,0}),quot;quot;,CB9)))), quot;#,##0quot;)))quot;Biffquot; wrote:

gt; Hi!
gt;
gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
gt; to NUMBER.
gt;
gt; Try this:
gt;
gt; =ISTEXT(U14)
gt; =ISNUMBER(U14)
gt;
gt; Select an empty cell. Make sure this cell has not been preformatted and its
gt; format is the default GENERAL.
gt; Goto Editgt;Copy
gt; Select cell U14
gt; Goto Editgt;Paste Specialgt;Add
gt; OK
gt;
gt; Did that straighten things out?
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; news
gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;
gt; gt; 170lt;186,000 comes up TRUE
gt; gt;
gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt; =U14lt;U15 comes up FALSE
gt; gt;
gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;
gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt; each
gt; gt; other, no change...)
gt; gt;
gt;
gt;
gt;

P.S. are you saying I Should.. or Can format cells used for formula's /
calculations as: General? thanks

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
gt; to NUMBER.
gt;
gt; Try this:
gt;
gt; =ISTEXT(U14)
gt; =ISNUMBER(U14)
gt;
gt; Select an empty cell. Make sure this cell has not been preformatted and its
gt; format is the default GENERAL.
gt; Goto Editgt;Copy
gt; Select cell U14
gt; Goto Editgt;Paste Specialgt;Add
gt; OK
gt;
gt; Did that straighten things out?
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; news
gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;
gt; gt; 170lt;186,000 comes up TRUE
gt; gt;
gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt; =U14lt;U15 comes up FALSE
gt; gt;
gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;
gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt; each
gt; gt; other, no change...)
gt; gt;
gt;
gt;
gt;

trying to apply to cells related to equations using seems to wipe out all
cond. formatting. Is this something I have to do.. / to start over in a
column to verify all cells working? thanks

- cell long equation (cond. formatting refers to.. x) has custom formatting
set:
,,#.0 (for some reason excel changes to: #.0,, )
that is spot where equation is not functioningquot;Biffquot; wrote:

gt; Hi!
gt;
gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
gt; to NUMBER.
gt;
gt; Try this:
gt;
gt; =ISTEXT(U14)
gt; =ISNUMBER(U14)
gt;
gt; Select an empty cell. Make sure this cell has not been preformatted and its
gt; format is the default GENERAL.
gt; Goto Editgt;Copy
gt; Select cell U14
gt; Goto Editgt;Paste Specialgt;Add
gt; OK
gt;
gt; Did that straighten things out?
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; news
gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;
gt; gt; 170lt;186,000 comes up TRUE
gt; gt;
gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt; =U14lt;U15 comes up FALSE
gt; gt;
gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;
gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt; each
gt; gt; other, no change...)
gt; gt;
gt;
gt;
gt;

Hi, seems to be 99% working.. works this situation as column is a calculated
field (non-issue in a text column with cond. formatting referring to other
items? as would not occur?),

the thing I see as very odd is that procedure added a 0 (plus zero)
directly to the end of my long equation. For now will assume that is ok / is
the ultimate fix/ answer...

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
gt; to NUMBER.
gt;
gt; Try this:
gt;
gt; =ISTEXT(U14)
gt; =ISNUMBER(U14)
gt;
gt; Select an empty cell. Make sure this cell has not been preformatted and its
gt; format is the default GENERAL.
gt; Goto Editgt;Copy
gt; Select cell U14
gt; Goto Editgt;Paste Specialgt;Add
gt; OK
gt;
gt; Did that straighten things out?
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; news
gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;
gt; gt; 170lt;186,000 comes up TRUE
gt; gt;
gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt; =U14lt;U15 comes up FALSE
gt; gt;
gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;
gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt; each
gt; gt; other, no change...)
gt; gt;
gt;
gt;
gt;

update fix was for cond. formatting to work, pasting a format free /
general format cell, as paste-special-add to fix cell, fixed conditional
formatting to start to work. Equation in cell stopped working as a (...) 0
was placed around entire formula, (which seemed negate the ? Not/ filter
prefix being used in formula), therefore when source cells empty, Value
Errors show up with complet columns having ##### sign errors in column.
Only conclusion is not sure what best choice is, including using xl...
unless I missed something else?

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is set
gt; to NUMBER.
gt;
gt; Try this:
gt;
gt; =ISTEXT(U14)
gt; =ISNUMBER(U14)
gt;
gt; Select an empty cell. Make sure this cell has not been preformatted and its
gt; format is the default GENERAL.
gt; Goto Editgt;Copy
gt; Select cell U14
gt; Goto Editgt;Paste Specialgt;Add
gt; OK
gt;
gt; Did that straighten things out?
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; news
gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;
gt; gt; 170lt;186,000 comes up TRUE
gt; gt;
gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt; =U14lt;U15 comes up FALSE
gt; gt;
gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;
gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt; each
gt; gt; other, no change...)
gt; gt;
gt;
gt;
gt;

It quot;soundsquot; like you have a real mess on your hands!

Unfortunately, you've lost me! I can't follow what you're doing.

Biff

quot;nastechquot; gt; wrote in message
...
gt; update fix was for cond. formatting to work, pasting a format free /
gt; general format cell, as paste-special-add to fix cell, fixed conditional
gt; formatting to start to work. Equation in cell stopped working as a
gt; (...) 0
gt; was placed around entire formula, (which seemed negate the ? Not/ filter
gt; prefix being used in formula), therefore when source cells empty, Value
gt; Errors show up with complet columns having ##### sign errors in column.
gt; Only conclusion is not sure what best choice is, including using xl...
gt; unless I missed something else?
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is
gt;gt; set
gt;gt; to NUMBER.
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =ISTEXT(U14)
gt;gt; =ISNUMBER(U14)
gt;gt;
gt;gt; Select an empty cell. Make sure this cell has not been preformatted and
gt;gt; its
gt;gt; format is the default GENERAL.
gt;gt; Goto Editgt;Copy
gt;gt; Select cell U14
gt;gt; Goto Editgt;Paste Specialgt;Add
gt;gt; OK
gt;gt;
gt;gt; Did that straighten things out?
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;nastechquot; gt; wrote in message
gt;gt; news
gt;gt; gt; Hi, don't know what is wrong, small question?? ugh
gt;gt; gt; have equations involved, but simple version also shows as in same cell:
gt;gt; gt;
gt;gt; gt; 170lt;186,000 comes up TRUE
gt;gt; gt;
gt;gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt;gt; gt; =U14lt;U15 comes up FALSE
gt;gt; gt;
gt;gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt;gt; gt;
gt;gt; gt; (right click all cells format: number, same each / paste formats over
gt;gt; gt; each
gt;gt; gt; other, no change...)
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
060326/7: Less than/ Greater than logic flipped. thanks in advance.
hope not too much detail, questions a for PROCEDU (good proc?)

Select empty cell. Make sure cell not preformatted (no what?),
and format is default GENERAL.
Goto Editgt;Copy, select destination cell; Editgt;Paste Specialgt;Add

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: quot;0.00quot; or quot;#,##0quot;

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 quot;quot;
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 gt;1000, and output to show as 1k= 1.0)

=IF(OR(AND(BC9=quot;quot;,BD9=quot;quot;,CB9=quot;quot;),AND(BC9=quot;quot;,OR($BT $2=quot;fmquot;,EXACT(F9,quot;Bquot;)))),quot;quot;,IF($BT$5gt;=1000,TEXT(TR UNC((

$BT$5/IF(OR($BT$2=quot;fmquot;,EXACT(F9,quot;Bquot;),AND(BC9lt;gt;quot;quot;,BD9=quot;quot;) ),BC9,IF(BD9lt;gt;quot;quot;,BD9,IF(OR(CB9={quot;quot;,0}),quot;quot;,CB9)))/1000),2),quot;0.00quot;),TEXT((

$BT$5/IF(OR($BT$2=quot;fmquot;,EXACT(F9,quot;Bquot;),AND(BC9lt;gt;quot;quot;,BD9=quot;quot;) ),BC9,IF(BD9lt;gt;quot;quot;,BD9,IF(OR(CB9={quot;quot;,0}),quot;quot;,CB9)))), quot;#,##0quot;)))Hi, found what might be answer, along with your info that also helpd.. thank
you very much: value(...)

quot;Biffquot; wrote:

gt; It quot;soundsquot; like you have a real mess on your hands!
gt;
gt; Unfortunately, you've lost me! I can't follow what you're doing.
gt;
gt; Biff
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; update fix was for cond. formatting to work, pasting a format free /
gt; gt; general format cell, as paste-special-add to fix cell, fixed conditional
gt; gt; formatting to start to work. Equation in cell stopped working as a
gt; gt; (...) 0
gt; gt; was placed around entire formula, (which seemed negate the ? Not/ filter
gt; gt; prefix being used in formula), therefore when source cells empty, Value
gt; gt; Errors show up with complet columns having ##### sign errors in column.
gt; gt; Only conclusion is not sure what best choice is, including using xl...
gt; gt; unless I missed something else?
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; U14 is probably TEXT. It can still be TEXT even though Formatgt;Cells is
gt; gt;gt; set
gt; gt;gt; to NUMBER.
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; =ISTEXT(U14)
gt; gt;gt; =ISNUMBER(U14)
gt; gt;gt;
gt; gt;gt; Select an empty cell. Make sure this cell has not been preformatted and
gt; gt;gt; its
gt; gt;gt; format is the default GENERAL.
gt; gt;gt; Goto Editgt;Copy
gt; gt;gt; Select cell U14
gt; gt;gt; Goto Editgt;Paste Specialgt;Add
gt; gt;gt; OK
gt; gt;gt;
gt; gt;gt; Did that straighten things out?
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;nastechquot; gt; wrote in message
gt; gt;gt; news
gt; gt;gt; gt; Hi, don't know what is wrong, small question?? ugh
gt; gt;gt; gt; have equations involved, but simple version also shows as in same cell:
gt; gt;gt; gt;
gt; gt;gt; gt; 170lt;186,000 comes up TRUE
gt; gt;gt; gt;
gt; gt;gt; gt; but when have in separate cells: 170 in U14 amp; 186000 in U15
gt; gt;gt; gt; =U14lt;U15 comes up FALSE
gt; gt;gt; gt;
gt; gt;gt; gt; =U14gt;U15 comes up TRUE cannot figure out problem
gt; gt;gt; gt;
gt; gt;gt; gt; (right click all cells format: number, same each / paste formats over
gt; gt;gt; gt; each
gt; gt;gt; gt; other, no change...)
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;