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

Top