| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
"Decopk" wrote in message
... I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! Have your number in a1 and this formula i b1: =if(a160;60;if(a1<0;0;a1) You might need to use "," instead of the ";". ";" is the standard delimiter with Norwegian regional settings. Rgds Thomas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Number Format () Not available | Excel Discussion (Misc queries) | |||
| How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
| Sum - show negative number? | Excel Discussion (Misc queries) | |||
| thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
| how do i subtract a negative number | Excel Worksheet Functions | |||
Threaded Mode
