May 14 2020 11:45 AM
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 equals two other cells. Those two cells are hard numbers. For example, 4 bottles in one cell minus 3.9 bottles in another which equals .1 of a bottle in yet another cell.
I've attached a pic below.
What I need is for every .01 variation in I3 to equal the $1.36 value per ounce in D3 in J3. But I need everytime there is more variation to continue to calculate. So if the variation was .02 it would calculate$2.72. There is a pre existing formula in both columns. I then need to copy that formula all the way down the sheet, which I know how to do.
May 14 2020 12:00 PM
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
May 14 2020 12:09 PM
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?
May 14 2020 12:19 PM
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
May 14 2020 12:50 PM
May 17 2020 08:59 AM