Thread: cell ref
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default cell ref
On Sun, 16 Nov 2008 09:41:00 -0800, markwmansell
wrote:

can i link cells so when ever i put can 1 in a cell it will auto put sc in
the cell next to it?

If the two cells are A1 and B1, then

B1: =if(a1=1,"sc","")

--ron
Reply With QuoteReply With Quote