Thread: Write a number in a cell and another number comes out in another c
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Write a number in a cell and another number comes out in another c
=IF(A1=0,0,IF(A1=1,5,IF(OR(A1=7,A1=8),8,IF(A1=9,13 ,"Not sure what to do"))))

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"max" wrote in message
...
I need a formula so that when for example I write 1 in cell A1,
automatically
it comes out 5 in cell A2. These are the numbers.

A1 A2
0 It comes 0
7 --------- 8
8 --------- 8
9 --------- 13


Reply With QuoteReply With Quote