Need help with excel message pop up
Solved/Closed
Related:
- Pop up message in excel without macro
- Voice message downloader - Guide
- Spell number in excel without macro - Guide
- Viber pop up after call - Guide
- Macros in excel download - Download - Spreadsheets
- Voice message in messenger - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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)))
