Data validation

[Medinukas]

Is there any way with data validation to restrict entry or leave the cell empty or with a sign if another cell has value.
For example if cell p3 has any value Q3 is blank or has a minus sign
Thanks in advance.

 

[Special-K99]

Try this

Data Validation
In Settings change Allow to Custom
and enter this as a formula

=(AND(P3<>"",OR(Q3="",Q3="-",Q3="+")))

Q3 will only accept blank, plus or minus if P3 has a value
otherwise it will accept anything.
(You didn't say what Q3 should accept if P3 DOESN'T have a value)

 

[Medinukas]

Try this

Data Validation
In Settings change Allow to Custom
and enter this as a formula

=(AND(P3<>"",OR(Q3="",Q3="-",Q3="+")))

Q3 will only accept blank, plus or minus if P3 has a value
otherwise it will accept anything.
(You didn't say what Q3 should accept if P3 DOESN'T have a value)

If p3 does not have any value Q3 should accept any value