Thread: Can you nest a MID function within a IF function in Excel
View Single Post
  #1   Report Post  
Dawn-Anne
 
Posts: n/a
Default Can you nest a MID function within a IF function in Excel
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?

Reply With QuoteReply With Quote