Problems

[Kay]

I need your help again.
What formula to use to do the following
If the number in a cell (B1) is 20 or less the max can enter in C3 is 15
cant go over 15 it can be less.
but if the number in the same cell (B1)is more than 20 the max can enter in
C3 is 20.
That is two argument for one cell

 

[Shane Devenshire]

Hi,

Select cell C3 and choose Data, Validation, from the Allow list pick Custom
and on the Formula line enter:

=IF(B1<=20,C3<=15,C3<=20)

 

[Teethless mama]

Data Validation:

=OR(AND(B1<=20,C3<=15),AND(B1>20,C3<=20))

 

[Kay]

The formula works, but is there a way for it to automatically enter 15 if I
entered more, when b1 is less than 20.(When I entered more the 15 I get a
message -USER RESTRICTED VALUE THAT CAN ENTER IN THIS CELL .....)
The next thing can I lock this formula from editing being that the cell is
need for other people's entry.