# Excel - IF Function Problem - Expert Solution

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

The below formula shows as #Value! =IF(AND(D25<14,D26<6),"REG 5",""), IF(AND(D25>15,D26<6),"REG 5",""), IF(AND(D25>31,D26<10),"REG 5","")
Solved by Z. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/04/2018 - 01:33
hi there!
Excelchat Expert 12/04/2018 - 01:33
just reviewing your IF formula now. I am going to create a quick example in the google sheet ->
User 12/04/2018 - 01:33
Hi, im trying to link several if formulas together, but it does not appear to be working.
User 12/04/2018 - 01:33
sure
Excelchat Expert 12/04/2018 - 01:36
i think the formula in the green cell should be good to go - =IF(AND(D25<14,D26<6),"REG 5", IF(AND(D25>15,D26<6),"REG 5", IF(AND(D25>31,D26<10),"REG 5","")))
Excelchat Expert 12/04/2018 - 01:36
give it a go on your sheet and let me know if it functions the way you need it to
User 12/04/2018 - 01:38
Thanks, that appears to work.
Excelchat Expert 12/04/2018 - 01:38
amazing!
User 12/04/2018 - 01:38
What was wrong with it?
Excelchat Expert 12/04/2018 - 01:39
you were so close...
Excelchat Expert 12/04/2018 - 01:39
OLD = =IF(AND(D25<14,D26<6),"REG 5",""), IF(AND(D25>15,D26<6),"REG 5",""), IF(AND(D25>31,D26<10),"REG 5","")
Excelchat Expert 12/04/2018 - 01:39
see how you put ,"" after each reg5
Excelchat Expert 12/04/2018 - 01:39
you only needed that at the end of the entire statement
Excelchat Expert 12/04/2018 - 01:39
Excelchat Expert 12/04/2018 - 01:39
just syntax stuff :)
Excelchat Expert 12/04/2018 - 01:40
please don't hesitate to ping us back if you need more help
User 12/04/2018 - 01:40
ahhahh ok, the help is appreciated!
Excelchat Expert 12/04/2018 - 01:40
:) have a great day friend

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.