John Erickson wrote: > > I'm trying to develop a scoring sheet in Excel. I need to know how to > reference a cell given a value, i.e. "if the number entered has a range > between 250 and 299, then multiply it times cell C16, if the number entered > has a range between 300 and 349, then multiply it times cell C17", etc. > > I know it is in the paste function area, but I don't use the program enough > to know how to do it. Any thoughts?
I use GNUmeric. Excel might be similar. The secret is the IF statement IF(condition, true, false) So in your case with A1 being the entered value (in another cell) =IF(A1>249, IF(A1>299, A1*C17, A1*C16), A1) -- Andrew E. Mileski Ottawa, Canada RCSE-List facilities provided by Model Airplane News. Send "subscribe" and "unsubscribe" requests to [EMAIL PROTECTED]
