View Single Post
 
Old 11-20-2018, 04:04 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thanks Xor, I adopted the shorter formula. Until now I could not make may brain cells to understand the two minuses before the formula. I came across the same functions when counting values in a range except blanks containing formulae. Also, I erroneously thought IFERROR and IF(ERROR) work the same.
Reply With Quote