![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
![]() |
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 |