• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Look for the correct percentage to multiply

Rodrigo

New Member
I have to match salary increases by multiplying a current salary by a certain percentage so that the current salary equals the salary offered.
If the salary offered in A1 = 110
If current salary in A2 = 100
The percentage in A3 would in this case be 10% so that the output of A2 & A3 in A4 = 110 and equals A1.
I have over 100 of these to do and would like a formula that would search %'s from 0-100% and then multiply the output by A2 to give me the answer in A4.

Thank you and kind regards
 
Back
Top