Description : I need to create a formula (something like IF) that would show me more options, eg if in Cell A there would be 90,100,110,120,130,140, then in cell B it would be 0.9..1..1,1..1, 2.1,3..1,4..1,5 ...
Last Answer : either a nested IF function (it goes up to 64 levels, but it's long and ugly) IF functions don't have to nest, but you can join them together using & and return the string = IF (A1 = 90; "0.9 ... and refer to the SEARCH ( VLOOKUP) or use the CHOOSE function, but in this case perhaps just = A1 / 100