Hey guys, thanks for all the great input here. Sorry for originally posting this in the wrong forum. I was originally thinking that formulas might somehow be associated with Excel Programming. I first tried Marcia’s approach and it failed. After reading ArviLaanemets informative bit on how the IFError works I’m thinking it maybe failed because there are provisions in my formula for errors. I used this formula with the ISERROR provisions because it was the only one I could find that was close to what I was trying to do. I try and dissect the formulas to see just how they’re working and it seems I should stay away from the IF/IS ERROR till I have a better basic understanding of how these formals work. For now Pecoflyer’s solution has solved the problem. I had seen this =IF(C2="","".. approach used in this forum but not with the “IF” statements and when I tried it earlier apparently I had applied it incorrectly. Thanks again for the help here.