Thread: if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sydbareit@gmail.com is offline
external usenet poster
 
Posts: 1
Default if statement

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.