Give this a try

=IF(OR(P13=835,P13=384,P13=386,P13=364),P13&R13&"0 0",IF(P13=585,583&R13&"00"
,IF(P13=627,0&30&R13&"00",IF(P13=7,0&17&R13&"00",I F(P13=646,147&R13&"00","NO
MATCH")))))

HTH

PC


"Kristajea" wrote in message
...
I am trying to get the following formula to work:


=IF(OR(P13=835,P13=384,P13=386,P13=364),(CONCATENA TE(P13,R13,0,0)),(IF(P13=5
85,(CONCATENATE(583,R13,0,0))),(IF(P13=627,(CONCAT ENATE(0,30,R13,0,0))),(IF(
P13=7,(CONCATENATE(0,17,R13,0,0))),(IF(P13=646,(CO NCATENATE(147,R13,0,0)))))
)))

IF P13 = anything other than the numbers in the first section of the
formula, I get a #VALUE error. I am using this to assist a data entry
function.