| 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 |
| 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 | |||
Threaded Mode
