Jun 13 2022 02:35 PM
I have row B12 currency amount. I need to deduct a % amount in C12 to get the sum for D12. Put another way, I need to do 100-10%
Jun 13 2022 02:38 PM
With the amount in B2 and the percentage in C12, the formula in D12 should be
=B12*(100%-C12)
Format D12 the same way as B12.