Calculating Gross salary

[LuckyRaju]

i want to calculate gross amount based on Net amount and  taxes

For ex:  Net amount : 1000

                   Tax : 10% 

            Gross Amount would be around 1111.   (  Gross Amount  (1111) - 10 % would be around 1000)

             Can you help me to get the flow or Macro achieve this logic,             

[binuacs]

@LuckyRaju What is the logic you are using to calculate the Gross Amount? I created a workflow maybe you can edit it according to the logic

[LuckyRaju]

I used calculator manually to get gross amount for 1000.  

logic would be :  add 1 to Net amount and subtract 10%. Repeat this process till you get 1000.  can we use Iterative macro?  if yes, can you please help me to create it. 

[ShankerV]

Hi @LuckyRaju 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @LuckyRaju 

Step 1: Input

Step 2: 

IF [Tax]=10
THEN ([Net amount]*.1111111)+[Net amount]
ELSE null()
ENDIF

Many thanks

Shanker V

[ShankerV]

Hi @LuckyRaju 

Tips: I have used the Net to Gross Calculator

https://www.omnicalculator.com/finance/net-to-gross

If you enter the Gross %, we will get the Net %

I have used the net % to calculate the Gross directly.

This will be useful if you have less number of tax percentage.

Many thanks

Shanker V

[binuacs]

@LuckyRaju I think the below formula should work

[LuckyRaju]

Thanks for the solution.

This will work only if the tax is 10 %.  Tax rate is also dynamic number. it should work for any tax rate and Any amount

[binuacs · Accepted solution]

@LuckyRaju Updated the workflow

If you don't have % in the tax then use the formula 

Round([Net amount]/(1-[Tax]/100),1)

[hlee36]

I'm a little confused.

Isn't this basic algebra? 1000 / (1-.10) =  1111.11. You don't need a macro.