Validation box formula

C

CLR

Hi All..........

I'm really having trouble with this........I want to apply Custom Validation
to a cell that will bring up the Error Message if BOTH of the following
conditions are met.
1- that the sum of G29:G48 is greater than zero, and 2- that the number
being entered in this cell with the Validation(G26) is less than the value
in F26.

Any help would be really appreciated.........

Vaya con Dios,
Chuck, CABGx3
 
P

Peo Sjoblom

This works for me

=(SUM($G$29:$G$48)>0)*($G$26<$F$26)

you might want to add some validation for F26 and G26 like isnumber
since text is considered greater than numbers, e.g.
if F26 holds "a" than you can put any number in G26 or if F26 holds "z"
then you can put "a" in G26

=(SUM($G$29:$G$48)>0)*($G$26<$F$26)*(ISNUMBER($F$26))*(ISNUMBER($G$26))
 
C

CLR

Thanks for the quick comeback Peo, but I still don't get it...........I'm
actually looking for a formula to put in the Custom Validation box for Cell
G26 . I want it to not allow any entry that is smaller than F26, IF the sum
of G29:G48 is greater than zero..........

I've copied and pasted each of the below formulas there and neither seemed
to work for me............I'm using WINme and XL2k..........perhaps I've
done something else wrong, or don't have something set right........or maybe
I didn't say it right the first time. In any event, any additional thoughts
will be appreciated..........

Vaya con Dios,
Chuck, CABGx3
 
P

Peo Sjoblom

If that's the case then you stated it wrongly in your first post

"that the number being entered in this cell with the Validation(G26) is less
than the value in F26"

not that it matters much, just a change of the sign

=(SUM($G$29:$G$48)>0)*($G$26>$F$26)*(ISNUMBER($F$26))*(ISNUMBER($G$26))

will prevent you from entering a number in G26 that is less than in F26
when sum(G28:G48) >0
 
C

CLR

That seems to do it fine...............thanks very very much...............

Vaya con Dios,
Chuck, CABGx3
 
Top