It appears that I have to enter data into a linked cell. I prefer to just
directly enter the value into it's own cell.

I have used the Validation option that Martin suggested.

Is there a way to enter a formula into a cell and then when it's time to
enter a value into that same cell, that the data doesn't overide the formula?

"David Biddulph" wrote:

If you want to contrain a value to be between 1 and 12, you can either use
=IF(A1<1,1,IF(A112,12,A1)) or
=MAX(1,MIN(A1,12)) or
=MEDIAN(1,A1,12)
--
David Biddulph

"Dr. Darrell" wrote in message
...
TY, This worked nicely.

I have another Cell that I have an entry which needs to be between 1 and
12
(Whole Numbers) I would like to do the same thing. If someone erroniously
enters a number larger than 12, I would like 12 to be displayed.

I was hoping that the reply to the first question would help me, but since
I'm not starting with a formula, I'm not sure how to enter the logic.

Can you demonstrate how to limit the display to no greater than 12?

Darrell

"Niek Otten" wrote:

Hi Darrel,

=MIN(IF(B4=0,0,IF(B6=0,0,B6/(PI()*(B4/12)))),600)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dr. Darrell" wrote in message
...
|I have a formula in a cell; =IF(B4=0,0,IF(B6=0,0,B6/(PI()*(B4/12))))
|
| I never want to display a result greater than 600 and if the result is
| greater than 600, I want 600 to be displayed.
|
| How do I alter my formula to achieve this?
|
| Darrell