Data validation

[Ahmad Syafiq Roslan]

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"

what I fill = "quantity' & "unit price"

data I want valid = sum for 5 column on "total price " can't be more than 450(table sum is 482)

2)

exp : based on attachment file "d"

Row 1(QC) & Row 2(ASS) is total sum from other spreadsheet

Row 3 is total sum for row 1 and row 2.

can I put validation data on row 3 can't be more than budget?

really appreciate on help.

thank you,

[#2 · Accepted solution]

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

[#3]

Hi may use validation with your formula to sum, like

=IF(SUM(..)>[limit], "Over the budget", SUM(...))

[#4]

hi sergei,

little bit confuse for "[]" symbol

but thank you very much.

awesome hahaa