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?