Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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 Replace @mailinator.com with @tiscali.co.uk "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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the value should not be more than 0.8
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|