help with "IF" function

[monkeytrader]

can someone help me with sorting a column of numbers?

a b c d
1 0.23
2 0.56
3 1.15
4 0.96
5 2.59

i need a function that will return any number from column A that is greater
than 0.75 into column B. thanks for your help.

 

[JulieD]

Hi

in B1 type
=IF(A1>0.75,A1,"")

and fill down (click on the cel B1, move your mouse over the bottom right
hand corner of the cell, when you see a little black cross hold your left
mouse down & drag).

Cheers
JulieD