![]() |
|
#1
|
|||
|
|||
![]() 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 |
#2
|
|||
|
|||
![]()
think i have solved it dose this look right
=IF(A2="","",IF(A2=-1,"N", IF(A2=0,"Y"))) |
#3
|
||||
|
||||
![]()
You can do this without a formula, using for a custom number format:
;"N";"Y"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
MATCH Function | namedujour | Excel | 1 | 07-20-2012 12:12 AM |
![]() |
gsrikanth | Excel | 1 | 01-07-2012 01:18 AM |
if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |
![]() |
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |