Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Test for a negative #
I need to test a cell value to determine if is negative or positive. If
negative, the value gets subtracted from partA and added to partB. If positive, it gets added to partA and subtracted from partB. I've seen a few posts close to this problem, but not close enough to help me. I'm stumped, my "if" statements keep running me in circles. I've got plenty of room offscreen to do this evaluation, but ... . Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
irritating warning for negative data on log charts | Charts and Charting in Excel | |||
NPV Calc appears incorrect with a large # of negative cash flows | Excel Worksheet Functions | |||
Negative Values Only | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |