Excel help
Closed
Vikram
-
Mar 15, 2010 at 01:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 10:02 AM
rizvisa1 Posts 4478 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.
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.
Related:
- Excel help
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 15, 2010 at 10:02 AM
Mar 15, 2010 at 10:02 AM
You can use datavalidation
Use custom and enter this formula
=IF(A1>=A2, TRUE, FALSE)
Use custom and enter this formula
=IF(A1>=A2, TRUE, FALSE)