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
 
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"))))
 

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

VBA Coding Help for Beginner 0
Referring to a cell by using another cell for the row number 6
Excel - Wich Function should I use? 1
Paragraph numbering in Word 1
Arriving at totals 2
Adding recognised Zeros 5
Drop down list control value in vba 2
Sum of Variable Cells in a fixed Row 3

Top