LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 57
Talking lock combination of cells

Hopefully my last question for this spreadsheet!!

I have a spreadsheet that calculates the effect of weight on a balance wherever the weight is placed.
I now want to be able to place some weights where I want them rather than have the spreadsheet calculate all the options for me.
To explain say there are 4 weights a,b,c,d and 4 positions 1,2,3,4
I can calculate all the permutations for the effect of these weights in all positions and return the optimum balance for me BUT i want weight "a" to be in position 1.(assuming position 1 address is a2) and return the optimum balance with this given condition.
I guess for a function I can use =if(a2=1,a2*ref arm,a2*999999) a2*999999 would return an unfavourable result andtherefore not be selected as the optimum.
My question is how can i create the input form for the user to stipulate which weight should be where so it is user friendly?
cheers
Nobby
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Lock and unlock cells conditionally depending on input in another Frustrated Excel Worksheet Functions 1 November 11th 05 03:36 PM
Can I use the grouping and lock and protect cells bfisher Excel Discussion (Misc queries) 1 January 11th 05 10:55 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"