Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stock data manipulation | Excel Worksheet Functions | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |