Help!

  • Thread starter iaimtomisbehave
  • Start date
I

iaimtomisbehave

Am a student that needs help!

I have a cell that i have the number 513 in, and another that has 51
in. Next to the 515 cell i want to put a function to say that the 51
is greater then the 513 and that it is ok to use the number 515, an
that if it was less then 513 it is not ok to use the number 515.

I also have the numbers 657, 234. If i do the same thing to thes
numbers to test if thare greater then 513, i want to be able to mark
box next to each of them to say which one of these three numbers
would like to use for the next part of the work, and the one i chos
shud be able to appere in another cell.

E-mail me please!

[email protected]
 
R

Roger Govier

Hi

Supposing you have your numbers 515, 657, 234 in cells A1,A2,A3 and you
have 513 in cell B1.
In cell C1 enter
=A1>$B$1
Copy down through cells C2:C3 and you will see results of TRUE, TRUE,
FALSE.
 
C

Carim

Hi,

If your cells are as follows :
cell A1 = 513
cell B1 = 515
cell B2 = 657
cell B3 = 234
Then in cell C1 you can type :
=IF(B1>$A$1,B1,$A$1)
and copy formula in cells C2 and C3

HTH
Cheers
Carim
 
Top