if statement

[sydbareit]

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)<6100.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.

 

[Dave]

sydbareit

Try something like this

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

Dave