Data Validation only applies to manually input data. It will not work on a
calculated formula.

You could use an IF Statement in A3, like:

=IF(A1*A25000,"ALERT",A1*A2)

Or, in a different cell, enter:

=IF(A35000,"ALERT","")

This second option may give you more room to also provide instructions if
needed.

HTH,
Elkar


"Rick" wrote:

I want to have data validation on a cell containing a formula. Is it
possible to have validation on the results of a formula and how do you do it?
Here is what I'm doing:

A1 (QTY) A2 (UNIT PRICE) A3 (EXTENDED PRICE)

A3 HAS THIS FORMULA =A1*A2

I want to have any value exceeding $5000 in A3 cause a data validation error
alert to appear with a message instructing what to do.