Validation

[Renarian]

Macro Skill Sheet Test.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1			Anger
2			Total			Precise Hitter			Hard Precise Hitter			Stunning Strike
3			0			0			0			0
4			Hard Hitter			0	% Crit Chance		0	% Crit DMG		0	% Extra Stun
5			0			Piercing Expert			Poison Expert			Poison Mastery
6			0	Max Weapon DMG		0			0			0
7	Total Used					0	% Piercing DMG		0	% More Poison DMG		0	% Poison Crit Chance
8	0					Blunt Expert			Bleed Expert			Bleed Mastery
9						0			0			0
10	Level					0	% Blunt DMG		0	% Bleed Dump DMG		0	% Bleed Dump Crit Chance
11	0					Slashing Expert			Harder Hitter			Berserker
12						0			0			0
13						0	% Slashing DMG		0	Max Weapon DMG		0	% DMG [<25% HP]
Sheet1

Cell Formulas
Range	Formula
C3	C3	=C5+F3+F6+F9+I3+I6+I9+L3+L6+L9+F12+I12+L12
F4	F4	=(F3*0.3)
I4	I4	=(I3*2)
L4,C6	L4	=L3
F7,F13,F10	F7	=F6*3
I7	I7	=I6*8
L7,I13,L10	L7	=L6*2
A8	A8	=C3+C17+C31
I10	I10	=I9*6
A11	A11	=A8/4
L13	L13	=L12*5

Cells with Data Validation
Cell	Allow	Criteria
C5	Whole number	<=3
C2	Any value
I6	Custom	=AND(F6<>"",F9<>"",F12<>"",SUM(F6,F9,F12),I6<16,MOD(I6,1)=0)
F6	Custom	=AND(C5<>"",C5=3,F6<31,MOD(F6,1)=0)
L3	Custom	=AND(I3<>"",I3>7,L3<11,MOD(L3,1)=0)
I3	Custom	=AND(F3<>"",F3>7,I3<31,MOD(I3,1)=0)
F3	Custom	=AND(C5<>"",C5=3,F3<21,MOD(F3,1)=0)
L6	Custom	=AND(I6<>"",I6>9,L6<21,MOD(L6,1)=0)
L9	Custom	=AND(I9<>"",I9>9,L9<21,MOD(L9,1)=0)
A10	Any value
A7	Any value
I9	Custom	=AND(F6<>"",F9<>"",F12<>"",SUM(F6,F9,F12),I9<16,MOD(I9,1)=0)
I12	Custom	=AND(F6<>"",F9<>"",F12<>"",SUM(F6,F9,F12),I12<11,MOD(I12,1)=0)
F12	Custom	=AND(C5<>"",C5=3,F12<31,MOD(F12,1)=0)
F9	Custom	=AND(C5<>"",C5=3,F9<31,MOD(F9,1)=0)
L12	Custom	=AND(I12<>"",I12>4,L12<21,MOD(L12,1)=0)

Got a lot of help from Dreid1011 on my work project and finished that thanks to them! Now using what I learned from that I am trying to create this. I tried a few things but reverted to this again because it works mostly how I want it. What I mean to use as an example, Is it possible for something like this:
C5 =or(or(F3=0,F6=0,F9=0,F12=0),and(C5<=3,mod(C5,1)=0)
for F3:
C5 =or(AND(C5<>"",C5=3,F3<21,MOD(F3,1)=0),and(I3=0,mod(f3,1)=0)
I am just throwing some things out as I am still learning all this. not sure if any of what I put is redundant or completely off base?

I have chain working just going left to right (up the chain), but I want to prevent users from going all the way up and then adding a false entry lower in the chain. There will be no blanks at all allowed in the sheet. All location for person data entry will have zero or a whole positive number smaller than a ceiling. Anything that is added/changed could there be a brief explanation of what it does or why the formula is better?
Original Article question formulas at the bottom of quote.
I know I posted this before but I seriously messed up the posting (lack of sleep). Thanks in advance

 

[Renarian]

I think maybe I should mention I have a simple macro tied to a button called reset that is just placing 0 in the field starting from right to left (this is why zero will always be there and no blanks.) Also is there a way to protect the data validation in the entry cells while still alowing users to enter data in those fields?

 

[Fluff]

Duplicate to: Two Way Conditional cells possibility?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.