Excel Chimp
Board Regular
- Joined
- Oct 30, 2008
- Messages
- 90
Is this possible? I have a cell that outputs a percentage between 0%-100% in cell H13. I'd like to check if cell H13 is within this range, if not, produce an error message and/or highlight the cell indicating is is not.
The formula I'm using in the data validation dialog:
=IF(AND(H13>0,H13<1),TRUE,FALSE)
I'm not getting anything with this.
Suggestions appreciated!
The formula I'm using in the data validation dialog:
=IF(AND(H13>0,H13<1),TRUE,FALSE)
I'm not getting anything with this.
Suggestions appreciated!
