https://youtube.com/watch?v=a15F-BBzo7QEasiest excel solution ever. How to fix the #N/A error in excel when you drag your formula. Simply add dollar signs where you don't want the cells to move. You…