Using numbers on Mac or IOS
This is what I would like the formula to do.
If value in A1 is / this goes in A2
1 / 12
2 / 10
3 / 9
4 / 8
5 / 7
6 / 6
7 / 5
8 / 4
9 / 3
10 / 2
11 or higer / 1
If cell has value of 1 or higher it enters a number of 1-12 in a different cell?
- Posted:
- 3+ months ago by ksrebuh81
- Topics:
- number, formula, different, cell, enter, cells, numbers, mac, ios
Details:
Added 3+ months ago:
This is what I've found but two problems.
=IF(ISNUMBER(SEARCH("1",H3)),"12",IF(ISNUMBER(SEARCH("2",H3)),"10",IF(ISNUMBER(SEARCH("3",H3)),"9",IF(ISNUMBER(SEARCH("4",H3)),"8",IF(ISNUMBER(SEARCH("5",H3)),"7",IF(ISNUMBER(SEARCH("6",H3)),"6",IF(ISNUMBER(SEARCH("7",H3)),"5",IF(ISNUMBER(SEARCH("8",H3)),"4",IF(ISNUMBER(SEARCH("9",H3)),"3",IF(ISNUMBER(SEARCH("10",H3)),"2",IF(ISNUMBER(SEARCH("11",H3)),"1","")))))))))))
1. The only correct outcome I get is with 1-9 (anything with a 1 in front of it will give me 12 not 1 so every 2 digit number I put in will give me the answer for the 1st digit and not 1.
2. It only works with excel and not numbers
Answers
No answers have yet been posted. Add your answer to this question.