| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell wording should change if result is +ve or -ve
I have a calculation with one cell containing the result. The wording next to the cell should read "Jane owes Peter:" if the result of the calculation is positive and "Peter owes Jane:" if the result is negative but it should show the absolute value. I am grateful for any help -- karambos ------------------------------------------------------------------------ karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262 View this thread: http://www.excelforum.com/showthread...hreadid=541726 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy the wording of a cell into a tab? | Excel Discussion (Misc queries) | |||
| No change in result cell | Excel Worksheet Functions | |||
| Result of IF conditional change cell color | Excel Discussion (Misc queries) | |||
| How do I change the color of a cell depending on the result of the function in that cell | Excel Programming | |||
| Change the color of a cell change dependant on a result | Excel Programming | |||
![karambos[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
