96.1k views
0 votes
To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12

User Mjh
by
7.0k points

1 Answer

3 votes

Answer:

For finding the largest quantity of items ordered from Rex Technologies the excel formula used is max(). Inside max you must specify the range of rex technologies quantity column cells just like if quantity is in D column and rex technologies items start from cell 4 to cell 7 then the formula will be max(D4:D7)

Step-by-step explanation:

In max formula first argument is starting cell of range and last is ending cell of range. In this scenario starting cell is D4 and end cell D7

User Fanlix
by
7.4k points