Formula help

		Microsoft Office Forums > Microsoft Excel > Excel
Formula help

FAQ

Thread Tools

Display Modes

12-20-2017, 09:55 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Quote:

Originally Posted by wheddingsjr

I will still have to make the deductions over 12 manually, but at least I do not have to go through all 30k lines manually.

Simply add another column, where you enter the formula (I havent Excel at moment, and I don't remember ecact column headings)
NewQty = OldQty + Correction

If I remember correctly, the correction was negative.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF(OR - IF(AND // Formula Help	Pixie	Excel	2	09-06-2017 11:12 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with IF formula	SMI	Word	3	01-19-2016 06:33 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula Help	ashreporter	Excel	3	04-01-2015 10:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:42 AM.