Be seen. Boost your question’s priority for more expert views and faster solutions

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?

=IF(D82="","",D82*E82*G82/

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?

If the data cells contain a mixture of numbers and arithmetic operators, then we need to parse those cells to extract the numbers.

=IF(D82="","",LEFT(D82,LEN

This formula assumes:

D82 is text that contains a number followed by a space and "x"

E82 is text that contains a number followed by a space and "="

F82 is a number formatted as percent. So you don't need to divide by 100.

G82 is text that contains a number followed by "-"

The desired calculation is 6*2.40*10% - (-1440)

I just need the following formula to = a positive qty, at the moment the following formula =

- 12.96, it must = 12.96

=IF(D82="","",D82*E82*G82/

If I understand correctly you shouldn't need to refer to cell F82 at all, in which case you could use the following formula:

=IF(D82="","",(D82*E82)-((

If you want to use an intermediate formula you could do:

=IF(D82="","",F82-(F82*G82

This is assuming that the formula in cell F82 is

=D82*E82

=IF(D82="","",((D82*E82)*1

Thanks

Rob H

=IF(D82="","",F82*(1-G82))

=IF(D82="","",F82*(1-G82/1

The reason for two possible formulas is I'm not sure that cell G82 actually contains the value 10%. If you put 0.1 in the cell and format using % format, it will display 10% and the first formula will work. If you put 10 in the cell, then you need to use the second formula.

The cell in question is i82

percentage-ddt-formula-error.xlsx

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

The formula you need is

=IF(E82="","",G82-(G82*(H8

Based on your references as originally described it is:

=IF(D82="","",F82-(F82*(G8