Validation procedure...

[Neo1]

Hello I have a problem with a validation procedure I want t
perform...Basically I have the following:

Amount Bought , Amount Sold, Buying price, Selling Price, Profit

Obviously the largest profit I could get is (Amount Sold x Sellin
price) - (Amount Bought x Buying price)...How can I do a validatio
procedure so that if for some reason the profit is larger than this i
shows an error?

Thanks a lot
From Joh

 

[Trevor Shuttleworth]

John

try something like:

=IF(Profit > AmountSold * (SellingPrice - BuyingPrice), "Check","")

Regards

Trevor