|
|
#1
12-02-2012, 08:42 AM
|
|||
|
|||
If formula result is negative then display text
Hello, I have a formula that I need to display text instead of the number if its a negative number or a zero. How would the formula go? Thanks!
Code:
E12-MAX(0,I13-60)-K13) 
|
|
#2
12-02-2012, 12:17 PM
|
||||
|
||||
|
Hi
could you explain some more please ? Something along the lines of =if( your_formula<=0,your_text,your_formula) perhaps?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
12-03-2012, 01:39 AM
|
|||
|
|||
|
Hi oxicottin
Try: =IF(E12-MAX(0,I13-60)-K13)<=0,"Your text here if true","Your text/value here if false")
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
 Display result in textbox based on the input of another textbox
|
scarymovie | Word VBA | 5 | 05-16-2012 07:05 PM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
|
Checkbox on Userform result in Text in Word
|
Dolfie_twee | Word VBA | 1 | 06-22-2010 07:54 AM |
Windows 7 32bit 
Office 2007
Linear Mode
