Limit Cell values

[dgraham62]

Hi,

Just needing to know if you can limit the value entered in a cell to be no more than double the value in another cell. ie.. if B1 = 4 then the data in cell B2 can not be more than 8.

Any assistance is appreciated

Regards
David

[6StringJazzer]

Yes. This is a perfect job for Data Validation.

Select B2
Go to the menu and select Data > Data Validation > Data Validation
For Allow select Custom
In the formula bar put

Please Login or Register  to view this content.

This is a formula that must always be true, or the data will not be allowed.

click OK to exit

[dgraham62]

Hi 6StringJazzer,

Thanks for the quick reply, I neglected to mention that there is another criterior as well, ie. depending if a person is a Male or Female .ie column D will show either M or F next to their names and depending on M or F will determin which row to be used in the validation ie. if Jo is M then B1, if Sue is F then B2 etc.

[FDibbins]

your request is confusing, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[dgraham62]

sorry cant seem to find how to upload file

[FDibbins]

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.