# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Am trying to set a numerical limit in a cell, that if data is entered into cell that exceeds the limit, the cell is flagged or a warning message appears?
Solved by M. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/06/2018 - 01:56
hello..??
User 06/06/2018 - 01:56
?
Excelchat Expert 06/06/2018 - 01:57
do you want to set limit on what you can input into cell..??
User 06/06/2018 - 01:58
no, i want to be notified when the limit is being exceeded
Excelchat Expert 06/06/2018 - 01:58
ok.. no problem..
Excelchat Expert 06/06/2018 - 01:58
do you have any examples.. ??
User 06/06/2018 - 01:59
0.004 & 0.004 have exceeded the limit of 0.003
Excelchat Expert 06/06/2018 - 01:59
ok... what limit do you want to setup for warning sign..
User 06/06/2018 - 01:59
lets say 0.003 here
Excelchat Expert 06/06/2018 - 01:59
0.003 will be upper limit for warning...??
User 06/06/2018 - 02:00
yep
Excelchat Expert 06/06/2018 - 02:00
are you going to use this in excel or google sheet..?
User 06/06/2018 - 02:00
excel
Excelchat Expert 06/06/2018 - 02:01
it's be little bit different..
Excelchat Expert 06/06/2018 - 02:01
Excelchat Expert 06/06/2018 - 02:01
first you need to select area ..
User 06/06/2018 - 02:01
ok
Excelchat Expert 06/06/2018 - 02:02
Excelchat Expert 06/06/2018 - 02:03
change criteria.. like what i did..
Excelchat Expert 06/06/2018 - 02:03
now it will show warning message when you input number bigger than 0.03
User 06/06/2018 - 02:04
thank you for your help, much appreciated
Excelchat Expert 06/06/2018 - 02:04
hold on..
Excelchat Expert 06/06/2018 - 02:05
you can try in google sheet or excel will be the same..
User 06/06/2018 - 02:06
thats great
Excelchat Expert 06/06/2018 - 02:06
in excel you need check option tap for Error Alert.
Excelchat Expert 06/06/2018 - 02:06
there is option for Warning and Stop..
Excelchat Expert 06/06/2018 - 02:07
You only need warning, so you need choose Warning..
User 06/06/2018 - 02:08
cheers
Excelchat Expert 06/06/2018 - 02:08
do you want excel file..for this..??
User 06/06/2018 - 02:09
yes pls
Excelchat Expert 06/06/2018 - 02:10
Excelchat Expert 06/06/2018 - 02:10
check yellow colored cell..
Excelchat Expert 06/06/2018 - 02:10
try input some numbers..
Excelchat Expert 06/06/2018 - 02:11
select yellow colored cell.. and click data>data validation menu to see how validation has been setup..
Excelchat Expert 06/06/2018 - 02:13
Excelchat Expert 06/06/2018 - 02:13
i changed little bit of validation formula..
Excelchat Expert 06/06/2018 - 02:13
now you can change limit of validation
Excelchat Expert 06/06/2018 - 02:14
You can use any of them...
Excelchat Expert 06/06/2018 - 02:15
is there any other questions for me...?
User 06/06/2018 - 02:15
ciao :)
Excelchat Expert 06/06/2018 - 02:16
ok.. thank you for the session..

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.