Solved
excel 2010 - if statement with % deduction in formula
Posted on 2013-05-09
hi experts, could you please assist with the following formula
=IF(D82="","",D82*E82*G82/100-F82)
what im trying to do here is;
if d82 = nothing then put in nothing, otherwise d82xg82/100-f82
ok so heres what are in these cells
d82 has 6.00 x
e82 has 2.40 =
f82 has 14.40-
g82 has 10%
the result to show in cell h82
so im looking for a formula to deduct 10% in this case but it wont always be 10% i will change this all the time so thats why its what ever i enter into the cell for the %.
please assist
Also, for some reason i cant print these solutions for some reason, there is 1 icon in experts exchange but then i have to click on "cntrl p" to print, is that right?