I am trying to write a formula that will check to see if there is an error in a specific cell and them return a value based on that. This is what I have so far.
=IF(IFERROR(C3, TRUE),IF(IFERROR(E3,TRUE),A3,""),"")
But all I am getting is A3 on the first 20 items on my list. Only about 6 of those should display data from A3.
Need some help figuring out what went wrong.
Bookmarks