If function for decades >1900, <1910

S

Simon

Hi,

This is not working.

The 1900 sames from (1900) which I've perfored a LEFT and RIGHT (or
MID) function on.

However it is not displaying the values whether the value is TRUE or
FALSE?

Help please

B1 is =LEFT(A1, 4)

Presuming A1 had "1904)" in the cell.

=If(B1>1900,B1, "")

This is a simpler version, but its not working. The cell returns
nothing. If I change it to e..g 1899, it still appears nothing. Even
changing cell B! to a value, cells are still blank.

Thanks for any help.
 
S

Stefi

Try this (because you ha a string in B1):
=If(B1>"1900",B1, "")

Regards,
Stefi

„Simon†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel thinks 1900 was a leap year??? 5
How do I make a function for < and > 9
IF Function 2
How to copy the function SUM but offseted in 7 columns 2
nested if 5
Excel Repeating a RAND() function under certain conditions 0
If function with text value 6
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Top