I can't open the attachments but in order to get the gross salary, computations must start from the net salary followed by a bit of trial and error in the tax rate. Try the attached sample. It needs input on desired net salary in B7 and the applicable tax rate in B6.
Attachment edited.
|