If displays #REF then value

[siroco79]

Hi there,

I am trying to display some text in a cell if the result of a different cell is #REF. How do I do that????

Many thanks!!

[ImStevenB]

Hi siroco,

Please Login or Register  to view this content.

This basically says if <Cell> has an error then do this (,result if true>) otherwise do this (<result if false>).

That should give you what you are looking for.

Hope this helps.

[siroco79]

Hi Steve,

Many thanks! It is right what I was after

[ImStevenB]

Happy to help.

Don't forget to mark the thread solved.

Have a great day.

[ImStevenB]

Deleted .. posted twice