Using Custom in Data Validation

  • Thread starter Thread starter Jerri
  • Start date Start date
J

Jerri

I want to create a limitation so that the entry into the
different areas of my form are not greater than a specific
cell-also entered by the user.

translated: the values of each product entered by user
cannot be greater than po value, also entered by user.

I have tried data validation, I chose Custom and put in
various formulas:

=Sum((c1+c2+c3)<=b6)
Sum((c1+c2+c3)<=b6)

but I am thinking it needs to be some sort of IF statement-
-I am just not sure what the right syntax would be.

Ideas?
 
Jerri

In cells C1, C2 and C3 enter the following custom validation formula.

=SUM($C$1:$C$3)<=$B$6

Tony

----- Jerri wrote: -----

I want to create a limitation so that the entry into the
different areas of my form are not greater than a specific
cell-also entered by the user.

translated: the values of each product entered by user
cannot be greater than po value, also entered by user.

I have tried data validation, I chose Custom and put in
various formulas:

=Sum((c1+c2+c3)<=b6)
Sum((c1+c2+c3)<=b6)

but I am thinking it needs to be some sort of IF statement-
-I am just not sure what the right syntax would be.

Ideas?
 
Back
Top