Thread: Using the if function in a formula,
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Using the if function in a formula,
Hi,

=IF(A1=2,Sheet2!A1,IF(A1=3,Sheet3!A1,""))

Mike

"Nick" wrote:

Im trying to create an IF forumla to tell excel to go to a different sheet in
my workbook if a cell value = 1.
How would I do this??
Reply With QuoteReply With Quote