I am doing an assignment for an emarketing course and I am trying to create a numerology formula, for the mock website we created I need the numbers to behave in a strange manner, like so a should = 1 b = 2 c = 3 d = 4 e = 5 f = 6 g = 7 h = 8 i = 9 but then j = 1 k = 2 l = 3 m = 4 n = 5 o = 6 p = 7 q = 8 r = 9 and then back again s = 1 t = 2Coffee or not, this is not a discussion i can enter ) howeveri am adhering to the 1234 up to $1300 by the end of the year it's not all that difficult and i like the way i've stretched a bit from week 1 and its $1 to this week, which is about $15 bitFor instance, to pull the 2 nd word from the string in , use this formula =TRIM(MID(SUBSTITUTE(," ",REPT(" ",LEN())), (21)*LEN()1, LEN())) Or, you can input the number of the word to extract (N) in some cell and reference
Ms Excel How To Use The If Function Ws
