Multiple IF formulas that are not nested still returning #VALUE!

		Microsoft Office Forums > Microsoft Excel > Excel
Multiple IF formulas that are not nested still returning #VALUE!

03-22-2020, 07:04 PM

Marcia

Windows 7 32bit Multiple IF formulas that are not nested still returning #VALUE!

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

To do away with the #value:
=IFERROR(your formula),"")

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word moves up multiple pages after returning to document	falcios	Word	4	08-23-2019 12:13 PM
VBA for ContentControl returning multiple lines of text	SuziBaz	Word VBA	5	04-13-2018 05:11 PM
Adding IF in nested formulas	caz46	Excel	5	03-30-2017 03:38 AM
Returning value based on multiple crtiteria	stockers	Excel	3	03-06-2017 05:05 PM
copying nested if over multiple rows where one value stays fixed	charles_cat	Excel	1	01-23-2015 01:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 PM.