<span style='font-family:Comic Sans MS'>I'm trying to create a ratio of 200:1 in Excel 2007 but I don't have a clue how to do it. I want the "1" to equal $1 USD and the "200" to equal 200 credits. I want to be able to just type in the number of credits or dollars and have the program automatically convert from one unit to the other. For example if I type in 5000 for the credits, I want it to automatically show $25 in a different cell or if I type in $5, I want it to show "1,000" in a certain cell. <a href=\'http://img523.imageshack.us/my.php?image=creditratioyi0.png\' target=\'_blank\'><img src=\'http://img523.imageshack.us/img523/9267/creditratioyi0.th.png\' border=\'0\' alt=\'user posted image\' /></a> Any help would be really appreciated.</span>
