Variance Column
 

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!

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!