Do not want the #value and #N/A

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

Hi Imran,

The first problem is solved by using a iferror formula around your formula.

=IFERROR(IF('SHIP & SALES'!R8="WIP,"WIP,0),"")

It looks to see if your formula results in a #N/A, then puts nothing in the cell. If you would like a different result displayed, then replace the "" with whatever you desire.

Hope this helps!!

Hi Potatoes and Onios

Thank you! It really work. Do you know how to solve the second problem?

I think you would have to format sheet one with the same format as sheet two. I don't think the format transfers between sheets on a formula result.

ooh thanks potatoes. I didnt think about that. Anyway, thank for your help.