If formula result is negative then display text

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

12-03-2012, 02:12 AM

macropod

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

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

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]

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 04:19 PM.