| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Positive Results
How can I use a formula to subtract a number in one cell from a number in
another cell then display the result only if it is positive or greater than 0? |
|
#2
|
|||
|
|||
|
It would look something like this:
=IF(a1-a2=0,a1-a2,"") |
|
#3
|
|||
|
|||
|
=if(a1=b1,a1-b1,"")
"lmthomas" wrote: How can I use a formula to subtract a number in one cell from a number in another cell then display the result only if it is positive or greater than 0? |
|
#4
|
|||
|
|||
|
That did it! Thank you for your help.
" wrote: It would look something like this: =IF(a1-a2=0,a1-a2,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating results in formulas | Excel Discussion (Misc queries) | |||
| SUMIF positive values only from database | Excel Worksheet Functions | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| positive integer? | Excel Discussion (Misc queries) | |||
Linear Mode
