Computer Science, asked by IceWeb, 4 months ago

Suggest the Excel function which can be used for the following-
•To calculate the quarterly sales of a sales executive,if the sales data of all months are given.
​

Answers

Answered by HA9650
12

HEY MATE, HETE'S YOUR ANSWER...!!

We can get the month from a date using MONTH() formula. If we divide the month by 3 and then round the value up to nearest integer we will get the Quarter.

So,

A formula like =ROUNDUP(MONTH(B4)/3,0) should tell us the quarter for the month in the cell B4.

ENJOY YOUR DAY...!!! :)

Attachments:
Answered by dvk71
1

Answer:

yes it is correct answer ⁉️⁉️.

Explanation:

wow!?. nice work ok.

Previous Question
Next Question
Similar questions
Math, 2 months ago
1×6×8×7+7-8+565+666-77×665 solve this xD​...
Hindi, 2 months ago
"महाराव, आज राजपूतों को एक सूत्र में गूंथे जाने की बड़ी आवश्यकता है और जो व्यक्ति यह माला तैयार करने की ताकत रखता है, वह है महाराणा लाखा |" क) वक्ता और श्रोता कौन है ? वाक्य का संदर्भ स्पष्ट कीजिए | ख) राणा लाखा बूंदी को मेवाड़ के अधीन क्यों करना चाहते थे ? ग) वक्ता ने महाराणा लाखा के सम्बन्ध में क्या कहा ? घ) राव हेमू के अनुसार हाड़ा वंश किस प्रकार का अनुशासन मान सकते हैं ?
Geography, 2 months ago
Explain two way process of human environment relationship in equatorial region with suitable example...
Sociology, 4 months ago
Write five moral value that we need to follow in our daily life briefly describe ..No spamming ​...
Math, 4 months ago
Draw a line segment AB of length 5 cm . At A and B , construct lines perpendicular to AB . Also , draw the perpendicular bisector of AB . Are these three lines parallel to each other ? Justify your answer​...
Physics, 10 months ago
if f(x)=x^3-1/x^2+1 then find the value of f(f(1))...
English, 10 months ago
To write a paragraph about good habits of eating.
Music, 10 months ago
अलंकार किसे कहते है ?