View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
helpless101
 
Posts: n/a
Default the value of a box in excel if entered data is a certain value

If i enter 6 or less in c2 then i want the value to be 10. If I enter 7 in c2
then i want the value to be 15, 8 then 20 and so on. I want my entered data
to show but behind the scenes in formulas i want the what if value used. I am
new and need some basic help. Also with using check boxes