Nov 17 2022 07:28 PM - edited Nov 17 2022 07:33 PM
I am working on a workbook and have a WORKING =IF formula, but, AFTER a certain number of rows it spits out a #NAME error, but, I have no misspellings in the formula as it has worked for the previous 25-90 rows depending on the sheet I am using.
The example below is what my function/formula currently looks like...
=IF(J3=2021,(TBL!$C$2*Thomas!C3)+(TBL!$C$3*Thomas!D3)+2500,IF(J3=2022,(TBL!$E$3*Thomas!C3)+(TBL!$E$4*Thomas!D3)+3500,” “))
Any help would be greatly appreciated!
Nov 17 2022 08:31 PM