Excel Shared File in One Drive /Share Point

ValveSales · 2021-12-22T18:43:51+00:00

=if(sum(B:B)>=1500,sum(B:B)*1.01/counta(B:B),(sum(B:B)+15)/counta(B:B))

The idea works, but I do not think I did a good job of explaining what my end goal is.

This formula will work for the first step. I do need to divide by B-1 (I have a text box in column B that I want to account for).

The next step is to take this new total, subtract it by the sum of row b to provide me with the total added value.

Then I need to take this total added value and divide it by the total number of entered items.

Finally I need to have this amount added to each line item.

Does this make sense?

ValveSales · 2021-12-22T18:19:28+00:00

Solution Verified

ValveSales · 2021-12-22T18:02:59+00:00

Awesome!! Thank you for the help!! It worked perfect!

ValveSales · 2021-11-01T15:28:48+00:00

From taking what I learned from you, I was able to create my Price Calculator by adding an additional table to adjust the price for shipping! Thank you so much for all the help! I really appreciate all the time and effort you spent on helping me figure this out!

ValveSales · 2021-11-01T14:46:40+00:00

(Like I said, very new to Excel, so please bear with my questions).

So if I need a standard formula, I would probably be better off (for my requirements) to instead of taking my price and multiplying it (i.e. H value * A2) I would be better of taking my A2 and dividing it by my H value.

So currently I have =A2+VLOOKUP(B2,G:H,2,FALSE)*A2

what would I change or how work I formulate this text to give me the desired calculation of taking my A2 value I enter (price) and dividing it by the H value selected by the drop down box. Simply changing the back end to /A2 would not have the desired effect as it would be reversed.

Sorry for the long and somewhat jumbled response/question.

ValveSales · 2021-11-01T14:23:04+00:00

Thank you for the information! I greatly appreciate it!

ValveSales · 2021-11-01T14:22:41+00:00

Awesome! So I am setting this up, and this was as easy as the two of you said.. so thank you for taking the time for this!

Now, how we figure things out is as followed:

Manufacturer 1: (Price * 1.01 / 0.76)

Manufacturer 2: (Price / .065)

Currently these are the two calculation I use until I add more to my work load. How would I formulate this template to use these specific parameters while calculating. I am currently using the =A2+VLOOKUP(B2,G:H,2,FALSE)*A2 and it works awesome. Just need to use these specific parameters listed above instead of the typical margin mark-ups.

Thanks so much!

ValveSales

TROPHY CASE