Variance Column
Try this:
=MIN(A1+B1,0)
This returns whichever value is lower (A1+B1) or 0.
HTH,
Elkar
"kumul8" wrote:
I am a complete nitwit and am trying to do an indepth expense sheet. I
have a variance column adding two other columns together. I would like
it to show as 0.00 when the outcome is positive and show the actual
outcome when the outcome is negative (amazingly I have figured out the
red font part!). Is this possible and how can I acheive it? Thanks for
any help and suggestions!
|