Prev: Searching from a table
Next: How to get result by using CountIF, if there are 3 conditions to b
From: srpavar on 5 Jul 2008 06:59
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: Mike H on 5 Jul 2008 07:09
Hi,

> 1.8 > 0.8
> 3.8 > 0.6

I can understand why 1.8 becomes 0.8 but why does 3.8 get converted to 0.6?

Mike



"srpavar" 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.
>
From: sajay on 5 Jul 2008 07:22
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: Mike H on 5 Jul 2008 07:33
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: Sandy Mann on 5 Jul 2008 07:53
What is the logic in 1.8 becoming 0.8, 3.8 becoming 0.6, 3.5 becoming 0.7
etc?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2(a)mailinator.com
Replace @mailinator.com with @tiscali.co.uk


"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.
>
>


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