multiple formula in the same cell

[adriana25]

please help, i want to do this formula in excel in the same worksheep if is possible. for example in the cell A1 i have a number 5000. the formula have to do like this: until 2100*7%=147; the difference(2900 * 18%=522), and then i have to aditionate 147+522=669; all thi in a one cell

Thank you very much

 

[AlphaFrog]

Try something like this...

=A1*7%+MAX(A1-2100,0)*11%

 

[villy]

What output you are expecting here?

 

[adriana25]

AlphaFrog thank you sooooo much for your idea . This formula needs me to calculate the tax from salary. So if the salary is until 2100 then the tax is 7%, if is superiour then until 2100 *7%, the difference 18%. I made this formula

+IF(A1<=2100;A1*7%;(2100*7%)+(A1-2100)*18%) and it is worked

thanks so so so much... im so glad that i find this forum