Question description:
This user has given permission to use the problem statement for this
blog.
I need to create a multiple IF rule formula, =IF(B5="Mon"&C5="Cleaning",E5)+IF(B6="Mon"&C6="Cleaning",E6) - this is the formula I've concluded but it doesnt work. Cells B5,C5 are drop down cells.
Solved by M. U. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
24/05/2018 - 04:28
Hi
Excelchat Expert
24/05/2018 - 04:29
Hello
Excelchat Expert
24/05/2018 - 04:29
We are glad to have you with us today here at excelchat.
Excelchat Expert
24/05/2018 - 04:29
Please tell what you are trying to achieve.
User
24/05/2018 - 04:29
I need to create a multiple if formula, that allows cells to add if 2 complying cells selected on a drop down menus in seperate cells are selected
Excelchat Expert
24/05/2018 - 04:30
Can you please show me the file?
Excelchat Expert
24/05/2018 - 04:30
Or some sample data? I'm finding it hard to understand just from the provided description.
User
24/05/2018 - 04:31
Can you see the screen im working on?
Excelchat Expert
24/05/2018 - 04:31
Yeah, I can see that.
User
24/05/2018 - 04:31
Ok so for example
User
24/05/2018 - 04:32
if A3="AD"&B3="ED"+C3
User
24/05/2018 - 04:32
this would be my formula but doesnt work
User
24/05/2018 - 04:32
ill show you
Excelchat Expert
24/05/2018 - 04:33
I get the A3="AD" and B3="ED" part, but after that I don't know why +C3
User
24/05/2018 - 04:34
Im trying calculate values in cell c3 as example when 2 certain drop selections are made
Excelchat Expert
24/05/2018 - 04:34
The two conditions IF formula should be written as like this.
Excelchat Expert
24/05/2018 - 04:35
=IF(AND(A3="ad",B3="ed"),value-if true,value-if false)
Excelchat Expert
24/05/2018 - 04:36
Making sense?
User
24/05/2018 - 04:36
Yes that's perfect, thank you very much
User
24/05/2018 - 04:36
I was confusing myself with the multiple rule
Excelchat Expert
24/05/2018 - 04:37
Glad that I was able to help you out.
Excelchat Expert
24/05/2018 - 04:37
Anything else you want to know?
User
24/05/2018 - 04:37
That's everything for now, thank you very much!
Excelchat Expert
24/05/2018 - 04:38
Thank you for visiting got it pro.
Excelchat Expert
24/05/2018 - 04:38
The session will end in 10 minutes unless you opt to close it before.
Excelchat Expert
24/05/2018 - 04:38
Have a great day.
User
24/05/2018 - 04:38
Thanks, you too1
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.