Hi guys

I hope you guys must be already know what i want based on the title. I have this formula =IF('SHIP & SALES'!R8="WIP,"WIP,0) and ='SHIP & SALES'!W8 in a sheet but i do not want the formulated cell show the #value and #N/A if R8 and W8 does not have any value.

Second thing is that I already format a cell (i.e A1) in sheet2 to custom (DO900000) and if i type 8 in that cell, it will appear D0900008 but when I make a formula in sheet 1, ='Sheet2'!A1 it will appear no. 8 not the whole D0900008. I want the cell show all D0900008

So, can someone help me with this two problems? please.

Thank you,
Imran