You are trying to calculate forecast gross profits for the next 12 months based on...
90.2K
Verified Solution
Question
Accounting
You are trying to calculate forecast gross profits for the next 12 months based on forecast sales figures and a fixed profit margin. The forecast sales figures are in cells B6 to M6 and the profit margin percentage is in cell B2. If you wish to enter a formula in cell B8 that can be copied across to M8 to give the gross profit for each month, which of the following formulae would be unsuitable?
A) "=$B$2*B6"
B) "=B$2*B6"
C)"=$B2*B$6"
D)"=$B$2*B$6"
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.