Thread: Help with IF or ELSE Formulas
View Single Post
 
Old 07-23-2014, 09:04 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
This should do it for all, I think.

Lower:
=B11-OFFSET($I$4,LEN(B11)-FIND(".",B11),0)

Upper:
=B11+OFFSET($I$4,LEN(B11)-FIND(".",B11),0)
Reply With Quote