Now you have two options:
Either recreate it again or go through it manually one step at a time, OR Use the 2 formula debugging techniques I am about to share. Keep reading!
Excel Formula Debugging Method #1 – F9 Key
Here is how this works: For example, suppose you have the text TrumpExcel in Cell A1, and in cell A3 you have the following formula:
Excel Formula Debugging Method #2 – Evaluate Formula Step by Step
Other Excel tutorials you may find useful:
!REF# Error in Excel – How to Fix the Reference Error! Use IFERROR with VLOOKUP to Get Rid of #N/A Errors Excel IFERROR Function #NAME Error in Excel – What Causes it and How to Fix it!
