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