copy a cell with a OR fuction in excel 1

[jupops]

Good evening all

I am still having troublr with OR fuctions, what I am trying to do is when a criteia is true then it will copy the cell or place in a zero.

I am using the two formulas

=IF(MID(C1,4,1)="/",C1,0) and =IF(MID(C1,4,1)="-",C1,0)

bothe formuldas work seperately but I cant merge them. Can you help?

Thgank you

Jupops

 

[Zathras]

Since MID(C1,4,1) cannot be both "/" and "-" at the same time, I will assume you really mean it to be an OR relationship:

=IF(OR(MID(C1,4,1)="/",MID(C1,4,1)="-"),C1,0)

 

[jupops]

Thank You, this as worked perfectly

Cheers

Jupops