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?
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?
It would look something like this:
=IF(a1-a2>=0,a1-a2,"")
It would look something like this:
=IF(a1-a2>=0,a1-a2,"")
That did it! Thank you for your help.
"[email protected]" wrote:
> It would look something like this:
>
> =IF(a1-a2>=0,a1-a2,"")
>
>
That did it! Thank you for your help.
"[email protected]" wrote:
> It would look something like this:
>
> =IF(a1-a2>=0,a1-a2,"")
>
>
=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?
=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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks