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


M

max

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
 
Ad

Advertisements

B

Bernard Liengme

=IF(A1=0,0,IF(A1=1,5,IF(OR(A1=7,A1=8),8,IF(A1=9,13,"Not sure what to do"))))
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referring to a cell by using another cell for the row number 6
Adding recognised Zeros 5
How to count the maximum number flanked by zeros 9
Finding last cell with a value and then adding to another 2
Excel Need Countifs Formula Help 0
Excel formula, sum the value cell and if empty cell left blank 0
How to count the maximum number of consecutives? 9
counts repeated number in two seperate area 1

Top