Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LEAVE BLANK IF NEGATIVE
I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1 minus-Column B1 is negative. If A1 -B1 is positive it would enter the result. Help please!!!! If A1 - B1 = Positive figure, enter the result in C1 If A1 - B1 = Negative figure, do not enter result in C1 -- Carolan |
#2
|
|||
|
|||
=IF(A1-B1=0,A1-B1,"")
HTH Jason Atlanta, GA -----Original Message----- I know this can be done.....just don't know how. Trying to create a formula that would leave the cell Column C1 empty if the result of Column A1 minus-Column B1 is negative. If A1 -B1 is positive it would enter the result. Help please!!!! If A1 - B1 = Positive figure, enter the result in C1 If A1 - B1 = Negative figure, do not enter result in C1 -- Carolan . |
#3
|
|||
|
|||
Try this:
=IF(MAX(A1-B1,0)=0,"",A1-B1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Carolan" wrote in message ... I know this can be done.....just don't know how. Trying to create a formula that would leave the cell Column C1 empty if the result of Column A1 minus-Column B1 is negative. If A1 -B1 is positive it would enter the result. Help please!!!! If A1 - B1 = Positive figure, enter the result in C1 If A1 - B1 = Negative figure, do not enter result in C1 -- Carolan |
#4
|
|||
|
|||
Thank you!!!!
"Jason Morin" wrote: =IF(A1-B1=0,A1-B1,"") HTH Jason Atlanta, GA -----Original Message----- I know this can be done.....just don't know how. Trying to create a formula that would leave the cell Column C1 empty if the result of Column A1 minus-Column B1 is negative. If A1 -B1 is positive it would enter the result. Help please!!!! If A1 - B1 = Positive figure, enter the result in C1 If A1 - B1 = Negative figure, do not enter result in C1 -- Carolan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
Make a cell blank? | Excel Worksheet Functions |