Need help with excel message pop up
Solved/Closed
Related:
- Pop up message in excel without macro
- Pop up reminder in excel free download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel without vba - Guide
- Sorry friends my facebook account was hacked message ✓ - Facebook Forum
- Message cannot be saved as draft yahoo ✓ - Yahoo Mail Forum
3 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 5, 2010 at 04:40 PM
May 5, 2010 at 04:40 PM
you need help with msgbox or the if statement ?
I don't know what would easier. I basically want only certain values to be valid in a specific field. And if an incorrect value is added a message to display
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 6, 2010 at 07:07 AM
May 6, 2010 at 07:07 AM
Is it for data validation ? By this I mean do you want prevent user to type in any thing that is less than 10 or have any thing greater than 50 which is not a multiple of 5
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 6, 2010 at 09:13 AM
May 6, 2010 at 09:13 AM
Hey Trowa. how that graph thing is coming up.
This work for me for the original question, in the validation I have this formula
=IF(A1="",TRUE,IF(OR(A1<10,AND(A1>50,MOD(A1,5)<>0)),FALSE,TRUE))
it allows if data is either "", or is >10 and <50 or is >50 but is a multiple of 5
For your question to only allow a value between 10 and 50 when it is not divisible by 5
=IF(A1="",TRUE,IF(OR(A1<10, A1>50, MOD(A1,5)=0),FALSE,TRUE))
or this
=NOT(AND(A1<>"",OR(A1<10,A1>50,MOD(A1,5)=0)))
This work for me for the original question, in the validation I have this formula
=IF(A1="",TRUE,IF(OR(A1<10,AND(A1>50,MOD(A1,5)<>0)),FALSE,TRUE))
it allows if data is either "", or is >10 and <50 or is >50 but is a multiple of 5
For your question to only allow a value between 10 and 50 when it is not divisible by 5
=IF(A1="",TRUE,IF(OR(A1<10, A1>50, MOD(A1,5)=0),FALSE,TRUE))
or this
=NOT(AND(A1<>"",OR(A1<10,A1>50,MOD(A1,5)=0)))