Forum Discussion
Generate result based on selected text
Hello, everybody! I need your help! 🙂 Please see the attached image. I have to calculate de Gross salary from Net and we have 2 situations: when the gross salary is calculated normally when t...
Let's say Net Salary is in D2 and the Yes/No for 10% Deduction is in E2. The formula for Gross Salary would be
=D2*2-IF(E2="Yes",10%*D2,0)
or
=D2*(2-10%*(E2="Yes"))
Thank you very much, Hans!
Really appreciate you showed interest. This is the second time you are a real help to me.
Best regards!
Really appreciate you showed interest. This is the second time you are a real help to me.
Best regards!