| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
varying a cll value from min to max
Hi, I am writing from Germany so sorry for my bad English! I have got following problem: I want to change a value of a cell from the minimum to the maximum in defined steps. For example: I know, that the value varies form 5 to 10, I want to say ecel "change it in steps of 1" and after that I can vary the value from 5 to 6 etc up to 10 by using the mouse. My aim is that I want to see what happens if a parameter changes from a to b.... I am thankful for answers that include an instruction like "first click there then do this etc" because I am new in excel. Thank you so much! Martin -- Martin K ------------------------------------------------------------------------ Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810 View this thread: http://www.excelforum.com/showthread...hreadid=573722 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
varying a cll value from min to max
Hi Martin,
one way is open the form bar, you will see a butom with two arrows one to up and one to down, click on it, drawing on your sheet. right click - Control Setup - setup as you need. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Martin K" escreveu: Hi, I am writing from Germany so sorry for my bad English! I have got following problem: I want to change a value of a cell from the minimum to the maximum in defined steps. For example: I know, that the value varies form 5 to 10, I want to say ecel "change it in steps of 1" and after that I can vary the value from 5 to 6 etc up to 10 by using the mouse. My aim is that I want to see what happens if a parameter changes from a to b.... I am thankful for answers that include an instruction like "first click there then do this etc" because I am new in excel. Thank you so much! Martin -- Martin K ------------------------------------------------------------------------ Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810 View this thread: http://www.excelforum.com/showthread...hreadid=573722 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
varying a cll value from min to max
Hi Marcelo, thanks a lot! It works. Vielen Dank aus Deutschland. Muito obrigado pela sua ajuda! Martin Marcelo Wrote: Hi Martin, one way is open the form bar, you will see a butom with two arrows one to up and one to down, click on it, drawing on your sheet. right click - Control Setup - setup as you need. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Martin K" escreveu: Hi, I am writing from Germany so sorry for my bad English! I have got following problem: I want to change a value of a cell from the minimum to the maximum in defined steps. For example: I know, that the value varies form 5 to 10, I want to say ecel "change it in steps of 1" and after that I can vary the value from 5 to 6 etc up to 10 by using the mouse. My aim is that I want to see what happens if a parameter changes from a to b.... I am thankful for answers that include an instruction like "first click there then do this etc" because I am new in excel. Thank you so much! Martin -- Martin K ------------------------------------------------------------------------ Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810 View this thread: http://www.excelforum.com/showthread...hreadid=573722 -- Martin K ------------------------------------------------------------------------ Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810 View this thread: http://www.excelforum.com/showthread...hreadid=573722 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Varying Column Widths for Text Import | Excel Discussion (Misc queries) | |||
| Varying page Excel report | Excel Discussion (Misc queries) | |||
| How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
| VARYING number of sheets in EXCEL | New Users to Excel | |||
| Varying axis scaling | Charts and Charting in Excel | |||
Linear Mode
