Thread
:
Ignoring #VALUE in formula calculations
View Single Post
11-09-2018, 02:55 AM
Marcia
Windows 7 32bit
Office 2007
Expert
Join Date: May 2018
Location: Philippines
Posts: 551
If the reference in your formula includes a cell with an error, it will return an error value. But if you mean you would not want error values appearing after executing your formula, use =IFERROR(your formula),"")
Marcia
View Public Profile
Find all posts by Marcia