golf spreadsheet

Originally Posted by GOLFER

hello, I need a formula. How can you make a number in a spreadsheet equal a different number. Here's the skinny: Par equals zero (not higher or below par) Birdie equals -1...so our event has pars worth 2 points birdies worth 4. I have entered all the scores and a coinciding table with the reference to par -1, +2, etc- now I want a table that converts that number to the coinciding points...thanks in advance

Checkout the VLOOKUP function.