numbers and percentages

[Anteri]

Hello there, I have problem with my formula my brain is stuck and cant find a way to continue.

Atm my formula looks like this:

=--IF(G6>2999,99;(G6*0,03);IF(G6>1999,99;(G6*0,02);IF(G6>999,99;(G6*0,01);IF(G6>0,01;0))))

In G6 I have positive numbers I wanna make it keep going that way if the numbers is negative also if g6<0 to -999,99 still 0
then from -1000 to -1999,99 to calculate 1% of that then the same from -2000 to -2999,99 2 % and -3000 or more %3

 

[steve the fish]

Hi. Try using ABS(G6) rather then just G6.

 

[Anteri]

Hi. Try using ABS(G6) rather then just G6.

Hi and thx for the reply,
Sorry but can you be more specific, can you put an example of what shoube my next statement

 

[steve the fish]

You can use the same formula but where you see G6 replace it with ABS(G6) instead.

 

[Anteri]

You can use the same formula but where you see G6 replace it with ABS(G6) instead.

Got it, thx it worked !

 

[Anteri]

I have new issue now, if cell G6 is 1000 i get 1% of it in g8 = 10 wich is fine, but when its -1000 i still 10. I need % to be also minus when g6 is minus ( example: if g6=-1000 g8= -10.00 ) Is there a way to make that ?

 

[steve the fish]

Multiply the whole formula by SIGN(G6)

 

[Anteri]

How can I do that

 

[Anteri]

nvm I did it but now I dont get 0 when the number in my cell is between -999 and +999 why . It hapends after I mutiply the forumula