**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

you had the logic correct!

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.*