View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default Setting up functions and rules

Hi all!

I have a column with different numers (actually prices). I want to be able
to set something up so each number can be given a certain value in the next
column. This is hard to explain and I hope I make sense...

Column A will have various numbers. I'd like to make a rule that says...

0-100 in column A. Add $5 and multiply by 1.03 to give me a value in column
B.