Microsoft Excel help?

Question

If I have typed a number in cell A1 and another no. in cell A2 and I want that in cell A3 the number which is lower of both cells A1 and A2 should appear by way of a formula (without using the 'copy' 'paste' option), then what should I do?

Answer 1

You can also Use the "IF" function.

The formula wil be like this:

=IF(A1

Answer 2

=min(a1:a2) is right.

You mean substract A1 and A2? Or you want numbers to be decreasing?

If substracting:
Type in A3 " =A1-A2" reverse A1 and A2 if you want the answer to be negative.

If you the numbers appear to be decreasing:
Type in A1 "10" or any number you want.
Then in A2 "=A1-1" then put your mouse at the lower right corner of the cell until cursor turns into a cross.
Then click and drag all the way down up to the cell you want.

Have fun!

Answer 3

In cell A3 type the following:

=MIN(A1:A2)

That will give you the lowest number from cell A1 or A2.

Answer 4

The answers give above are right

Click on A3 and type "=min(A1:A2)"

Answer 5

Click on A3 and type "=min(A1:A2)"

Answer 6

=IF(A2>A1,A1,A2)
I like the MIN function wen I have a large list

Answer 7

Lemme wager, you're in a working laptop or computing device Literacy classification... in line with threat with the paintings Institute??? because of the fact whats humorous is it rather is the right question of this weeks first task. weird and wonderful. "Week 3: Week 3 - W3: task a million talk talk question 3 evaluate Microsoft notice, Microsoft Excel, and Microsoft PowerPoint. while might desire to you utilize each and each of those applications? while are you able to apply those applications interchangeably? supply examples and motives to assist your answer."

Answer 8

use the min function

use the search function feature to find it so that you get the pop up dialog to explain the options

Answer 9

are u a school student. u can use the min function

Answer 10

=MIN(a1:a2)