If formula result is negative then display text

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

FAQ

Thread Tools

Display Modes

12-02-2012, 12:17 PM

Pecoflyer

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

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

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

« Previous Thread | Next Thread »

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 06:08 PM.