ExcelBanter - if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if statement (https://www.excelbanter.com/excel-worksheet-functions/100180-if-statement.html)

I am try to create an if statement with 3 arrays, I created 2 arrays
and I am having trouble creating the third array. What I am try to do
is to have the sum of the cells in the row equal 6100.80. I need a
statement to calculate the difference in the cell that will take me to
6100.80.

=IF(SUM(Salary!M2*6.2%+B4+C4+D4+E4+F4+G4+H4+I4)<61 00.8,(Salary!M2)*6.2%,IF(SUM(Salary!M2*6.2%+B4+C4+ D4+E4+F4+G4+H4+I4)6100.8,6100.8))

Thank you.

sydbareit

Try something like this

=IF(SUM(B4:I4)<6100.8,6100.8-SUM(B4:I4),0)

Dave

wrote in message
oups.com...
I am try to create an if statement with 3 arrays, I created 2 arrays
and I am having trouble creating the third array. What I am try to do
is to have the sum of the cells in the row equal 6100.80. I need a
statement to calculate the difference in the cell that will take me to
6100.80.

=IF(SUM(Salary!M2*6.2%+B4+C4+D4+E4+F4+G4+H4+I4)<61 00.8,(Salary!M2)*6.2%,IF(SUM(Salary!M2*6.2%+B4+C4+ D4+E4+F4+G4+H4+I4)6100.8,6100.8))

Thank you.