Need help with Data Validation

[amburnham23]

The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The problem is that if I update the values and don't enter a value for C9 without updating C10, it allows C9 to be greater than C10. How can I avoid this? Or is there an easier way using an IF function?

 

[Superstar31]

The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The problem is that if I update the values and don't enter a value for C9 without updating C10, it allows C9 to be greater than C10. How can I avoid this? Or is there an easier way using an IF function?

Can I see an example?


Never mind I get your problem....