I have to solve this cryptogram by providing formulas in each position of the secret message (with the formulas being able to carry over in each row of the message).

In the secret message, the numbers 2 to 34 have replaced letters and punctuation marks. The key to the cryptogram is in column A, where either a numeric value or color label is listed for each of the numbers in the secret message. The decode tables to the right are for finding which letter or punctuation mark is being represented in the secret message.

Sorry I'm still very new to excel spreadsheet formulas and have never solved a cryptogram before! I know that I have to use the ISNUMBER function but dont know where to start! Thank you very much for the help!!

[/URL][/IMG]

In the secret message, the numbers 2 to 34 have replaced letters and punctuation marks. The key to the cryptogram is in column A, where either a numeric value or color label is listed for each of the numbers in the secret message. The decode tables to the right are for finding which letter or punctuation mark is being represented in the secret message.

Sorry I'm still very new to excel spreadsheet formulas and have never solved a cryptogram before! I know that I have to use the ISNUMBER function but dont know where to start! Thank you very much for the help!!

Last edited: