create a formula that performs a calculation when a # is entered
Posted by Elizabeth B on January 29, 2002 8:50 AM
Hello! I download a program that shows the percent of totals and I would like to change that number to the exact opposite. I'd like a formula that converts that number within its own cell. I can do it in an adjacent cell, but can't seem to nail it within it's own. Example: cell b4 reads "25%". Change it to 75%, right in b4. cell b5 reads 15%. Change to 85%. And so on. I've been doing this: cell b4 reads 25%. formula in b5: =SUM(1-b4).