| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell wording should change if result is +ve or -ve
=if(a1=b1,"No debt",if(a1<b1,"Jane owes Peter: ","Peter owes Jane: "))
& text(abs(a1-b1),"$0.00") You can use the text() worksheet function to give the difference a nice format. =if(a1=b1,"No debt",if(a1<b1,"Jane owes Peter: ","Peter owes Jane: ")) & text(abs(a1-b1),"$0.00") & " due on: " & text(c1,"mm/dd/yyyy") (if you had the date in C1) karambos wrote: 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 -- Dave Peterson |
| Reply |
| 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)
Hybrid Mode
