If formula result is negative then display text

		Microsoft Office Forums > Microsoft Excel > Excel
If formula result is negative then display text

12-02-2012, 08:42 AM

oxicottin

Windows 7 32bit If formula result is negative then display text

Office 2007

Novice

Join Date: Dec 2012

Posts: 5

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)

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 AM.