![]() |
|
#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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sum Function
|
teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |
| MATCH Function | namedujour | Excel | 1 | 07-20-2012 12:12 AM |
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 |
Need help on what function to use???
|
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |