oops
min(cell, .80) should produce the results

these symbels are because this mail is replied/forwarded?



"Mike H" wrote in message
...
You may have meant MIN but this still doesn't give the values the OP
wanted

"sajay" wrote:

use this =max(a1,0.8) and copy down


"srpavar" wrote in message
...
i have a date in colum a like this
1.8
3.8
0.0
3.5
1.1
0.8
5.6
4.8
4.5
0.0
0.0
i want to write a formual in column B, if the value is greater than 0.8
then
the value should be less than 0.8, in this manner. at any point it
should
not
go above 0.8
0.8
0.6
0
0.7
0.6
0.8
0.8
0.5
0.4
0
0
can anyone help me in this, i would be very grateful, thanks in
advance.