| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells containing values not less than zero
Is there a formula I can include in an IF statement that would require the
number to be a positive figure. Or is it easier than that and I can format the cell to equal zero or greater. For example, if my formula wants to subtract cell A5 from A4, but but if A5 is larger than A4, 0 would be the answer. Thanks. -- Andrea |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells containing values not less than zero
=IF(A4-A50,A4-A5,0)
"Andrea" wrote: Is there a formula I can include in an IF statement that would require the number to be a positive figure. Or is it easier than that and I can format the cell to equal zero or greater. For example, if my formula wants to subtract cell A5 from A4, but but if A5 is larger than A4, 0 would be the answer. Thanks. -- Andrea |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells containing values not less than zero
Another idea ..
=MAX(A4-A5,0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Andrea" wrote: Is there a formula I can include in an IF statement that would require the number to be a positive figure. Or is it easier than that and I can format the cell to equal zero or greater. For example, if my formula wants to subtract cell A5 from A4, but but if A5 is larger than A4, 0 would be the answer. Thanks. -- Andrea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| Counting multiple values within single cells | Excel Worksheet Functions | |||
| cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
Linear Mode
