Leaving cell blank if certain value

Good morning,
Sorry to bother you, but I am stuck and would be most grateful if someone could point me in the right direction please, or let me know if not possible so I can stop tearing my hair out!!
I have a spreadsheet table which shows different things but in particular has a column of data ranging from numbers 1 to 23. I carry forward these numbers to display in a different table, so am simply linking from the second table into the first to bring that data forward (literally using formula =B1, in top cell, =B2 in second cell and so on). That's fine.
However I would like to be able to show a blank for any occurences of numbers 4, 14 and 24.
Is there a formula that I could use to firstly carry forward the data, but to then leave blank if the value is either 4, 14 or 24?
Thanks.

G'day

Try this

Place formula in cell B1 and copy down

=IF(OR(B1=4,B1=14,B1=24),"",B1)

Hi,

Something like this will do it

=IF(OR(A1=4,A1=14,A1=24),"",A1)

Hi,

Instead of

=[Book1]Sheet1!B2

write the following formula

= IF( OR( [Book1]Sheet1!B2 = 4 ,  [Book1]Sheet1!B2 =  14 ,  [Book1]Sheet1!B2 = 24 ) , "" , [Book1]Sheet1!B2)