Previous Topic Next Topic

Excel help

Closed
Vikram - Mar 15, 2010 at 01:29 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 10:02 AM
Hello,
Please help me with this
I want to limit my data entery in one cell.
for example the data enterd in cell A2 should be less than or equal to the value calcualted by formula
Suppose my formula is 2*100(50-48)
So the value in Cell A2 should not be more than the value calcualted from above formula. If value entered more then the value calucalted by the formula then it should give a error message.
any help in this regard.

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 15, 2010 at 10:02 AM
You can use datavalidation

Use custom and enter this formula

=IF(A1>=A2, TRUE, FALSE)
0