excel 97 data validation with a formula result

  • Thread starter Thread starter assws
  • Start date Start date
A

assws

What I have is I enter a value in say A1.
Cell B1 takes this value and does a calculation and the result i
placed in B1.

What I am trying to do is create a data validation that when thi
result is greater then a number (say 1000) the box will pop up and war
me of the bad result.

I tried using the allow "whole number" less then or equal to "1000" bu
when I test it I get results of more than 1000 and no error bo
occures.

Thanks
 
Hi

you're using the data validation on a cell this is filled by a formula.
Data validation will (AFAIK) only check manual input. So in your case I
would apply a data validation on call A1 and check if this value will
lead to a result >1000 or not

HTH
Frank
 
assws > said:
What I have is I enter a value in say A1.
Cell B1 takes this value and does a calculation and the result is
placed in B1.

What I am trying to do is create a data validation that when this
result is greater then a number (say 1000) the box will pop up and warn
me of the bad result.

I tried using the allow "whole number" less then or equal to "1000" but
when I test it I get results of more than 1000 and no error box
occures.

Thanks,
Click to expand...

You can't use data validation on a formula result. It's intended for
entering data.

You could have a formula in an adjacent cell such as this:
=IF(B1>1000,"BAD RESULT!","")
You could even use conditional formatting to make the cell go red when
B1>1000.

Or maybe you could limit the value in B1 to 1000, like this:
=MAX(your_equation_here,1000)
 
Back
Top