#1
|
|||
|
|||
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
|
||||
|
||||
Hi
could you explain some more please ? Something along the lines of =if( your_formula<=0,your_text,your_formula) perhaps?
__________________
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
|
|||
|
|||
Hi oxicottin
Try: =IF(E12-MAX(0,I13-60)-K13)<=0,"Your text here if true","Your text/value here if false") |
#4
|
||||
|
||||
Try:
=IF(E12-MAX(0,I13-60)-K13)>0,E12-MAX(0,I13-60)-K13),"Text to display")
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |