Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2013, 09:06 AM
msheyworth msheyworth is offline IF function Windows XP IF function Office 2007
Novice
IF function
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default IF function


I have googled unsuccessfully my problem which is a cell can show 3 different outcomes which are -1 , 0 , or blank and i need to use if to show for -1, N , for 0 ,Y , and for a blank cell to to show a blank cell tried
=IF(B3=0,"Y","N ") which gives me the Y and N but not sure how to add the if cell blank then show blank
Reply With Quote
  #2  
Old 03-25-2013, 09:17 AM
msheyworth msheyworth is offline IF function Windows XP IF function Office 2007
Novice
IF function
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default

think i have solved it dose this look right
=IF(A2="","",IF(A2=-1,"N", IF(A2=0,"Y")))
Reply With Quote
  #3  
Old 03-28-2013, 02:15 AM
macropod's Avatar
macropod macropod is offline IF function Windows 7 64bit IF function Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

You can do this without a formula, using for a custom number format:
;"N";"Y"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
MATCH Function namedujour Excel 1 07-20-2012 12:12 AM
IF function how to use now() function gsrikanth Excel 1 01-07-2012 01:18 AM
if function help jim831 Excel 2 10-29-2010 07:06 PM
IF function Need help on what function to use??? Primeraman Excel 1 06-13-2006 10:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 PM.


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