Thread: [Solved] IF function
View Single Post
 
Old 03-25-2013, 09:06 AM
msheyworth msheyworth is offline Windows XP Office 2007
Novice
 
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