ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

In Excel : which Formula of the following can you get the maximum number ? 1-min 2-max 3- sum 4-average

user-image
تم إضافة السؤال من قبل محمد نور الدين محمد الغندور al-ghandour , معلم جغرافيا , مدرسة زهراء الأندلس الثانوية
تاريخ النشر: 2016/01/19
RAJESH DESHKULKARNI GOPAL
من قبل RAJESH DESHKULKARNI GOPAL , Group Accounts & Tax Manager , Confidential Group

It's very simple question & answer

=MAX(range) then maximum number shall be your output/ answer =8 is answer for below example

3

2

1

4

8

=max(range)

Ahmad Hawi
من قبل Ahmad Hawi , Statistical Specialist , Qatar Development Bank

3. MAX

Max function returns the largest value from the numbers provided

Rogel Bañares
من قبل Rogel Bañares , Purchaser , Al Habtoor Leighton LLC

The MAX formula in excel returns the largest value from a supplied set of numeric values. So my answer is 2-max

Murtaza Jamal Hossain Murtaza
من قبل Murtaza Jamal Hossain Murtaza , Senior Manager Finance and Accounts , Jaiprakash Associates Limited

Answer is Max, In Excel we find minimum i.e. smallest number from the series of data using excel formula "min(<range>)". By “max(<range>) we get maximum i.e. greatest number from the data range and using excel formula “sum(<range>)” we get sum of the data series and mean or simple average of the data series from  excel formula “average(<range>).

Shams Tahir
من قبل Shams Tahir , Finance Officer , Rupani Foundation

MAX formula is to find the maximum 

Ayeda Yassine
من قبل Ayeda Yassine , Assistant Manager for HRD , Kayan Holding Co.

By using the following formula in excel we can get the maximum number : MAX

Omyma  Fouda
من قبل Omyma Fouda , Processing Team Member , Emirates Nbd

3. Max formula is to find the maximum 

Davinder Singh Davinder Singh
من قبل Davinder Singh Davinder Singh , Deputy Section Officer , Dayanand Medical College & Hospital, Ludhiana

MAX formula is used to get maximum number

Mohamed Awny
من قبل Mohamed Awny , Legal Assistant , Law House Advocates & Legal Consultants

2-(max) is the formula that will give the maximum number in excel

EMAD   ALALFY - CMA - CSCA
من قبل EMAD ALALFY - CMA - CSCA , Finance Manager , Architectural Al-Diyar Company

to get the maximum number we should use MAX formula

Abubaker Suliman
من قبل Abubaker Suliman , Customer Service Representative , Derby Marketing

By Using Max function formula        

المزيد من الأسئلة المماثلة