My formula for a worksheet is ="2/99/-4/-" &
IF(MID($C$8,7,1)=1,8,MID($C$8,4,1)) & "/980120", where C8 value is
2/02/-1/825100.
Cell returns 2 and not 8 as I had hoped. Any ideas?
My formula for a worksheet is ="2/99/-4/-" &
IF(MID($C$8,7,1)=1,8,MID($C$8,4,1)) & "/980120", where C8 value is
2/02/-1/825100.
Cell returns 2 and not 8 as I had hoped. Any ideas?
Hi Dawn-Anne,
You need to test for a string when using MID
="2/99/-4/-"&IF(MID($C$8,7,1)="1",8,MID($C$8,4,1))&"/980120"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dawn-Anne" <[email protected]> wrote in message
news:[email protected]...
> My formula for a worksheet is ="2/99/-4/-" &
> IF(MID($C$8,7,1)=1,8,MID($C$8,4,1)) & "/980120", where C8 value is
> 2/02/-1/825100.
>
> Cell returns 2 and not 8 as I had hoped. Any ideas?
>
Thanks Bob - worked a treat. Better start glueing my hair back in!
"Dawn-Anne" wrote:
> My formula for a worksheet is ="2/99/-4/-" &
> IF(MID($C$8,7,1)=1,8,MID($C$8,4,1)) & "/980120", where C8 value is
> 2/02/-1/825100.
>
> Cell returns 2 and not 8 as I had hoped. Any ideas?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks