Thread: Variance Column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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!