IF function

[msheyworth]

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

[msheyworth]

think i have solved it dose this look right
=IF(A2="","",IF(A2=-1,"N", IF(A2=0,"Y")))

[macropod]

You can do this without a formula, using for a custom number format:
;"N";"Y"