IF Formula issue!?!?

[nighthawk123]

Hi,

I am having trouble combining an IF and a mid formula...the mid formula on its own returns the text value I want, but when I use it in an IF formula I am not getting the correct result! Any ideas? The formulas are below for reference...

This returns what I want... =MID(IFERROR(IF(MID(G251,2,2)>0,OFFSET(G251,-MID(G251,2,2)-1,-6),""),""),55,8) (returns text value)

This returns 0... =IF((MID(IFERROR(IF(MID(G251,2,2)>0,OFFSET(G251,-MID(G251,2,2)-1,-6),""),""),55,8))="*",1,0)

 

[CRUTHERFORD]

Hi,

Can you upload the document you have so I can see what your dealing with?

Cheers,
C

 

[nighthawk123]

Unfortunately not, its a work issue, so the info is confidential. I was hoping this would be a common issue and somebody would know a way around it!