#VALUE! Displaying instead of " "

[Chris Waller]

Good Afternoon All,

I wonder if someone could point me in the right direction with a formula that returns #VALUE! when the formula is not True. The formula I have is: =IF(day(B71)=3,"Queen's Platinum Jubilee",""). So when B71 doesn't equal 3, I'd rather display a blank cell rather than the #VALUE! message. TIA

 

[RoryA]

You could use:

=IFERROR(IF(day(B71)=3,"Queen's Platinum Jubilee",""),"")

 

[Chris Waller]

You could use:

=IFERROR(IF(day(B71)=3,"Queen's Platinum Jubilee",""),"")

RoryA,

That was brilliant. Thanks so much for the prompt response. That has saved me so much time and effort.

Thanks again.

 

[RoryA]

Glad to help.

 

[Chris Waller]

RoryA,

Can I ask a supplementary question? Now that you have helped me with my virtual calendar, I am wondering what is the best way to automatically hide the row when the year in cell F1 doesn't equate to 2022/2023? I have password protected the Spreadsheet to protect the formulae, however, row 71 which contains the extra bank holiday for the Queen's Platinum Jubilee does not need to be visible in any other year.

TIA