Urgent

[kiran]

Hi All,

A B C
01/01/2009 11:10:00 AM 02/01/2009 11:10:00 AM
=IF(AND(B1="NA",B1>A1),"NA","Y")
01/01/2009 11:10:00 AM NA =IF(AND(B1="NA",B1>A1),"NA","Y")


can any one help me whats wrong in the given formula i want if B is greather
than A value i want Y or NA if B value is NA i want NA kindly help.

TIA

 

[Kassie]

B1 cannot have 2 values at the same time, hence AND will not work here. With
NA, do you mean #N/A, or an actual value called NA? If it is an error
condition, then NA will not trap it. Rather use IF(ISNA(B1). If it is
merely a value, you should rather use OR iso AND. (If B1 is either NA or
bigger than A1). =IF(OR(B1="NA",B1>A1),"NA","Y")

 

[Patrick Molloy]

=IF(B1="NA","NA",IF(B1>A1,"Y","N"))