Minimum Value of 1.00 in Cell

[BrachChad]

I have a cell that does not have a formula, but i need it to have a minimum value of 1.00 in it.

it can have larger number in it, but no lower than 1.00, it must always have a value in it.

Thanks for the help

Chad

 

[joeu2004]

[.... deleted by me ....]

 

[Scott T]

You can use data validation.

under Allow: select custom

for the Formula enter =K9>1 change K9 to match your cell.

This will give a message when someone tries to enter a value less then 1. You can customize this under the Error Alert tab

 

[tyija1995]

Hey, try a data validation rule on the desired cell:

Data Validation -> Settings Tab -> Allow: Custom -> Formula: =A1>=1

Then in cell A1 you will not be able to enter a cell that is less than 1.

 

[jim may]

Use Data Validation in your cell(say cell A1), Custom - Formula =A1>0

 

[BrachChad]

Thanks for the help.

I got it another way, but this works much better.

Very much appreciated.

Chad