Trying to create a Depreciation Schedule Master. I need 2 formula’s for 2 columns that show either the profit or loss . Columns C & D.
E.G. Column A has a figure $8,000.00 Column B shows sale of item $10,000.00 This is a profit of $2,000.00, which I want to show in Column C. If the figures were (Sales $6,000.00), then the Loss would appear in column D I NEED a formula for column C that states; IF B is GREATER than A then put the difference ($2000.00) here in column C ....... OR if it is LESS then leave Column C with 0.00. OR BLANK I NEED a formula for column D that states; IF A is GREATER than B then put the difference ($2000.00) here in column D ....... OR if it is LESS then leave Column D with 0.00. OR BLANK Also under what sub heading in the HELP area, can I find all the formula options. E.G +, /, –, *, sum, IF, etc Regards Rod --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
