| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Validation.
Hope you can help.
I have a formula that adds up some numbers in various cells. I need a validation rule to make the sum of the numbers, if negative, to show as 0. I have tried to no avail to get this to work. Any one got any ideas? Mark, |
|
#2
|
|||
|
|||
|
Hi
When your current formula is =CurrentFormula then =MAX(0,CurrentFormula) does exactly what you want. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Mark Solesbury" wrote in message ... Hope you can help. I have a formula that adds up some numbers in various cells. I need a validation rule to make the sum of the numbers, if negative, to show as 0. I have tried to no avail to get this to work. Any one got any ideas? Mark, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
