Forum Discussion
Looking for some help!
Hi morgansmith
Do you need the formula in J3 to multiply the contents of both D3 & I3? if so just use
= D3 * I3.
If however, you wanted additional conditions, please communicate or share the file that you can use as a sample.
Cheers
I'm not looking for it to just multiply. I need J3 to equal I3 but in dollar amount. The issue I'm having is that I3 is going to be a different value for each item. Essentially G3-H3 = I3, which should also equal J3. I3 needs to be the percentage it is but I need a dollar amount for J3 and I need it to be able to change in dollar format as I3 changes in decimal format. The more variance in I3 the more the variance should change in J3. Each .01 variance in I3 needs to equal $1.36 variance in J3.
Maybe that helps?
- I think what you might need in J3 is:
=-100*I3*D3
so if I3 contains -0.01 you would get -100*-0.01 = 1 * 1.36 = 1.36
if I3 contains -0.02 you would get -100*-0.02 = 2 * 1.36 = 2.72
and so on.
Does that help?
Peter- That worked! Thanks!
Hi morgansmith
Are you able to send a sample worksheet and put the value you intend to achieve for each case as well as the desired formatting?
I couldn't get your point clearly. A sample will aid in understanding.
Cheers
