Need help showing and hiding values, with cells that already have value (text)

[spazz21]

So I have 5 data cells.

What I want to do is only show data cell 3,4,5 "if" 1 & 2 have information in them.

Cell 3,4, 5 are already using a formula for random data into those cells. So I am unsure on how to do this....

Also want to be able to hide cell 4 & 5 "if" cell 3 has a specific value

Cell3 already uses formula =INDEX($AB:$AB,RANDBETWEEN(1,COUNTA($AB:$AB)),1)

cell 4 already uses formula =INDEX($AH:$AH,RANDBETWEEN(1,COUNTA($AH:$AH)),1)

cell 5 already uses formula =RANDBETWEEN(DATE(1992,1,1),DATE(2012,1,30))


Untitled.png

 

[spazz21]

Ok figured out the first half, still need to replace cell 4 and 5 with a "-" if cell 3 returns with "NO RECORD"