Forum Discussion
Solved
Data validation
Hi all, can you tech me how to use data validation wisely. I know how to put validation max number on entry column. but can i do it on sum table? 1) exp : based on attachment file "capture...
- Data validation can only be applied to data entered (not the resulting value in a cell, I think)..
you can try Conditional formatting to check your result.
HTH
Hi may use validation with your formula to sum, like
=IF(SUM(..)>[limit], "Over the budget", SUM(...))
hi sergei,
little bit confuse for "[]" symbol
but thank you very much.
awesome hahaa