Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to change current cell value
Is it possible make a cell display the value of Zero if the the cell
value is zero or less or less than 1? Even better is it possible to change the actual value using a formula under the same circumstances? thanks Robert |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to change current cell value
Max will do what you want:
=max(1,yourformula) Note: "zero or less or less than 1" is the same as "less than 1". -- Regards, Fred "Robert H" wrote in message oups.com... Is it possible make a cell display the value of Zero if the the cell value is zero or less or less than 1? Even better is it possible to change the actual value using a formula under the same circumstances? thanks Robert |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to change current cell value
This would result in 1 (or more, depending on yourformula), but the OP asked
for 0. Maybe: =if(yourformula1,yourformula, 0) Joerg "Fred Smith" wrote in message ... Max will do what you want: =max(1,yourformula) Note: "zero or less or less than 1" is the same as "less than 1". -- Regards, Fred "Robert H" wrote in message oups.com... Is it possible make a cell display the value of Zero if the the cell value is zero or less or less than 1? Even better is it possible to change the actual value using a formula under the same circumstances? thanks Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving current worksheet on cell value change | New Users to Excel | |||
How to set current day when a cell in a colum change | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
Can I get current #row or #column in cell formula? | Excel Discussion (Misc queries) | |||
Change Cell Color if in current Month | Excel Worksheet Functions |