This is the function that I have enter into Cell W6

=IF(J6:J323="Salary",IF(O6:O6O323>95000,O6*0.3,O6),O6)

I pressed ctrl+Shift+Enter to make it an array. The result is a #Name? error.



I have two columns of data. One says salary or hourly and the other has an amount. If the "salary" and ">95000" then I want to multiply the salary by .3 and put it in column W. If not, then I just want the salary in column W.

What am I doing wrong?