answersLogoWhite

0


Best Answer

(Column A) . . . . . (Column B) . . . . . (Column C) . . . . . (Column D)

"Q-1 Sales" . . . . "Q-2 Sales" . . . . "Difference" . . . "Percent Gain"

$1,500.00 . . . . . . $2,000.00 . . . . . . . = B1-A1 . . . . . . . . = C1/A1

Format Columns A, B, and C as "Format/Cells/Number/Currency"

Format Column D as "Format/Cells/Number/Percent"

Fill in the sales figures in Columns A and B.

Excel does the calculations for Columns C and D.

If second-quarter sales were less than first-quarter,

then Columns C and D will be negative numbers.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What Formula in excel will calculate the increase in sales form the first quarter to the second quarter as a percentage of first quarter sales?
Write your answer...
Submit
Still have questions?
magnify glass
imp