Thread: Multiple IF formulas that are not nested still returning #VALUE!
View Single Post
 
Old 03-22-2020, 07:04 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
To do away with the #value:
=IFERROR(your formula),"")
Reply With Quote