Variance Column

K

kumul8

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!
 
E

Elkar

Try this:

=MIN(A1+B1,0)

This returns whichever value is lower (A1+B1) or 0.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top