Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems
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 -- KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems
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) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kay" wrote: 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 -- KK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems
Data Validation:
=OR(AND(B1<=20,C3<=15),AND(B120,C3<=20)) "Kay" wrote: 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 -- KK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems
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. -- KK "Teethless mama" wrote: Data Validation: =OR(AND(B1<=20,C3<=15),AND(B120,C3<=20)) "Kay" wrote: 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 -- KK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROBLEMS PROBLEMS!! | Excel Discussion (Misc queries) | |||
SUM Problems | Excel Worksheet Functions | |||
Problems with IRM | Charts and Charting in Excel | |||
Tab Key problems | Excel Discussion (Misc queries) | |||
SP3 problems | Excel Discussion (Misc queries) |