Formula working intermittently

[paquirl]

I've never seen anything like this. I am using =IF(B1>A1,"greater","") and it works sometimes and other times the opposite it is supposed to do, or maybe not at all. Both columns formatted as number. I really want to flag when a value is greater or equal, but that version of the formula has even more failures. Any ideas?

 

[MARK858]

Are any of your cells text or errors rather than numbers?

To test put

=ISNUMBER(B1)

in the first row of a spare column and

=ISNUMBER(A1)

in the first row of another spare column, then drag both formulas down... they should all return TRUE

Both columns formatted as number.

It doesn't matter what they are formatted as, it is the underlying value that counts

 

[Micron]

IIRC, applying a format when the cells already have data in them does not always work. It looks like a duck, the formatting dialog says it's a duck but when you try to work with it, it barks. I'd try formatting a new column then pasting the values in. Seems to me that in reality your data is being regarded as text.

 

[paquirl]

i think you guys are correct, one of the columns comes up false when doing the =isnumber test

 

[MARK858]

Select the column Click Data, Text to Columns, Next, Check no checkboxes are checked, click Finish.
Have the ISNUMBER formula's changed to TRUE?

 

[paquirl]

YES !!

 

[MARK858]

Good, hopefully your other formula works correctly now

 

[felixstraube]

Check no checkboxes are checked

That's a funny one XD