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.