Prev: Searching from a table
Next: How to get result by using CountIF, if there are 3 conditions to b
From: sajay on 5 Jul 2008 08:12
oops
min(cell, .80) should produce the results

> > these symbels are because this mail is replied/forwarded?



"Mike H" <MikeH(a)discussions.microsoft.com> wrote in message
news:8C75FF55-0FFF-42F6-964D-510986246B9B(a)microsoft.com...
> 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" <srpavar(a)discussions.microsoft.com> wrote in message
>> news:FAA6A6B6-320D-4C4F-9452-50915E4F568C(a)microsoft.com...
>> > 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.
>> >
>>
From: Pete_UK on 5 Jul 2008 13:10
Another approach might be to use this:

=MOD(A1,0.8)

and copy down, but this does not always produce the numbers in your
example:

1.8 0.2
3.8 0.6
0.0 0.0
3.5 0.3
1.1 0.3
0.8 0.0
5.6 0.0
4.8 0.0
4.5 0.5
0.0 0.0
0.0 0.0

Hope this helps.

Pete

On Jul 5, 11:59 am, srpavar <srpa...(a)discussions.microsoft.com> wrote:
> 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.

First  |  Prev  | 
Pages: 1 2
Prev: Searching from a table
Next: How to get result by using CountIF, if there are 3 conditions to b