Display #N/A instead of 00-Jan-00

[Adelka]

Hello, world.

I need to display #N/A instead of 00-Jan-00 in the red M column in the attached sample. At the same time, I need the blank cells in columns B:I to remain blank, because of the other formula (in column L). As a result, in column O there should be #N/A instead of FALSE, if a user didn't see any book at all (like for example users Louis-Guy Meersseman and Dirk Flawinne).

Thank you a lot!

[Limor_OP]

Try this in O2 and down:
=IF(EXACT(A2,M2),"","N/A")

[AliGW]

Try this:

=IFERROR(1/(1/MIN(B2,D2,F2,H2,J2)),"#N/A")

[Pete_UK]

You can use this formula in M2:

=IF(SUM(B2,D2,F2,H2,J2)=0,NA(),IF(ISERROR(MIN(B2,D2,F2,H2,J2)),"",(MIN(B2,D2,F2,H2,J2))))

although you may need to use semicolons ( ; ) instead of commas ( , ). Then you can copy it down.

The formula in column O will not need to change, as it will return #N/A if that occurs in column M.

Hope this helps.

Pete

[Adelka]

You're great, Pete. This works. Thank you!

[AliGW]

There were two other people who offered help - don't ignore us, please.

[Limor_OP]

Mine was wrong I didn't understand the question right, but AliGW's does work...

[Adelka]

There were two other people who offered help - don't ignore us, please.

I'm really sorry, AliGW, I tried Pete_UK's advice in a hurry before meeting and forgot to come back to say thanks also to you. I still have a lot to learn.