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
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