Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2012, 08:42 AM
oxicottin oxicottin is offline If formula result is negative then display text Windows 7 32bit If formula result is negative then display text Office 2007
Novice
If formula result is negative then display text
 
Join Date: Dec 2012
Posts: 5
oxicottin is on a distinguished road
Default 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)
Reply With Quote
  #2  
Old 12-02-2012, 12:17 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If formula result is negative then display text Windows 7 64bit If formula result is negative then display text Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 12-03-2012, 01:39 AM
Kevin@Radstock Kevin@Radstock is offline If formula result is negative then display text Windows 7 32bit If formula result is negative then display text Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi oxicottin

Try: =IF(E12-MAX(0,I13-60)-K13)<=0,"Your text here if true","Your text/value here if false")
Reply With Quote
  #4  
Old 12-03-2012, 02:12 AM
macropod's Avatar
macropod macropod is offline If formula result is negative then display text Windows 7 64bit If formula result is negative then display text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
If formula result is negative then display text 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
If formula result is negative then display text 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 02:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft