ExcelBanter - Write a number in a cell and another number comes out in another c

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Write a number in a cell and another number comes out in another c (https://www.excelbanter.com/excel-worksheet-functions/210944-write-number-cell-another-number-comes-out-another-c.html)

Max

Write a number in a cell and another number comes out in another c

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

Bernard Liengme

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

Max

Write a number in a cell and another number comes out in anoth

That what I want. It works fantastic and thanks.

"Bernard Liengme" wrote:

=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

All times are GMT +1. The time now is 11:11 AM.