Forum Discussion
Looking for some help!
I need a formula! I'm trying to make a spreadsheet for bar inventory purposes. I have one cell that is a value of $1.36 per oz of liquid and another cell that has a pre existing formula that equa...
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
=-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!