Q
Questions in Excel
I want to string together multiple logic statements. IE: if I have a value
of 10 and 15 added together, they must equal at least 12. If they equal 12,
multiply 10 by 5%. That part is easy. "=if(10+12>15,10*.05,0) The problem I
have is when I add another value, say 16. Now if the total of 10+15+16 > 30,
the answer needs to be 0. This is for quarterly unemployment taxes, if that
helps.
I have searched everywhere I can think of for 2 months and cannot find an
answer.
Thnaks Matt
of 10 and 15 added together, they must equal at least 12. If they equal 12,
multiply 10 by 5%. That part is easy. "=if(10+12>15,10*.05,0) The problem I
have is when I add another value, say 16. Now if the total of 10+15+16 > 30,
the answer needs to be 0. This is for quarterly unemployment taxes, if that
helps.
I have searched everywhere I can think of for 2 months and cannot find an
answer.
Thnaks Matt