I have an inventory spreadsheet that contains two columns that use VLOOKUP to find a discount multiplier. One column contains standard discount multipliers and the other special negotiated multipliers that only apply to certain items. Some of the items in the special negotiated multipliers contain #N/A because they only have a standard discount.
I want to add a column that will compare the two columns and take the lower multiplier but only when there is values in each column. If the special discount column contains #N/A it should show the standard discount.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …