Add amount based on condition

Scottjcarter76

New Member
Joined
Dec 5, 2016
Messages
9
Hello all. Looking for help. Have a column of units representing weight. Wanting to easily create a new column to represent shipping weight.

Would like to know a good formula for adding 50 pounds to any number in the column over its original 100 pounds.

Best way to proceed would be? Will use this formula often!!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
to any number in the column over its original 100 pounds.
Could you explain this please?
 
Last edited:
Upvote 0
I have a spreadsheet that one of the categories/columns is "weight unit" that are in pounds (just the numbers are given not "lbs"). There are a variety of units/amounts. For everything over 100lbs I need to add an additional 50lbs so that the total in the new column would then be 150.

However I only need to add 50 to any number equal to or greater than 100.

What I would like to do is have a formula which allows me to highlight a whole section of numbers and any number 100 or greater automatically has 50 added to it without changing the amount for every number 99 and under.

Does that make more sense now?
Amy help you can give me would be appreciated!
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top