Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel |