If function

[username_rand]

Hi there,

I'm trying to use the value (text) returned from an If Statement in Cell (C4) as a condition in another cell (D4) but it does not seem to be working since the actual cell value is not the text rather the equation itself, is there a way around this or any other way to get it done?

=IF(AND(B4="No",C4="Is there a preferred source?"),"Multiple Quotations", " ")

Bold text is the result of the below If Statement in C4:
=IF(B3="No","Is there a preferred source?"," ")

Thank you

 

[Fluff]

There's nothing wrong with your formula & it should work.
In what way doesn't it work?

Also you could possibly simplify the formula in D4 to
=IF(C4="Is there a preferred source?","Multiple Quotations", " ")

 

[username_rand]

There's nothing wrong with your formula & it should work.
In what way doesn't it work?

it does not return the value "Multiple Quotations", it returns blank.

This is for a questionnaire i'm establishing using excel so i have to let all questions appear and most formulas would depend on similar cells but with different potential answers, if that makes sense to you.

 

[jorismoerings]

Hi,

I can't reproduce your results.

Book1
	B	C	D
2
3	No
4	No	Is there a preferred source?	Multiple Quotations
Sheet1

Cell Formulas
Range	Formula
C4	=IF(B3="No","Is there a preferred source?"," ")
D4	=IF(AND(B4="No",C4="Is there a preferred source?"),"Multiple Quotations", " ")

Could you share a mockup of how your sheet looks.
Will give us more info to go on.

 

[Fluff]

Is the formula in C4 meant to look at B3 or B4?
If B3, should D4 also be looking at B3 rather than B4?

 

[username_rand]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]What would you like to request?[/TD]
[TD]Service[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Is this the first request of the sort?[/TD]
[TD]No[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Is there a preferred source?[/TD]
[TD]No[/TD]
[TD]Multiple Quotations[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









[TABLE="class: grid, width: 800, align: left"]
<tbody>[TR]
[TD]B4[/TD]
[TD]=IF(C3="No","Is there a preferred source?", "Do you have knowledge of the number of potential suppliers?")[/TD]
[/TR]
[TR]
[TD]D4[/TD]
[TD]=IF(ÖR(AND(C4="No",B4="Is there a preferred source?"), AND(C4="No", B4=" Do you have knowledge of the number of potential suppliers?")) , "Multiple Quotations", " ")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






Apologies if i wasn't clear earlier, hope this gives you a better picture of what i'm trying to do. the formula in D4 keeps returning blank even if conditions are met.

 

[jorismoerings]

Hi,

Can you check if you are posting formula's with typo's within.
I still can't recreate your error:

Book1
	B	C	D
2	What would you like to request?	Service
3	Is this the first request of the sort?	No
4	Is there a preferred source?	No	Multiple Quotations
5
Sheet3

Cell Formulas
Range	Formula
B4	=IF(C3="No","Is there a preferred source?", "Do you have knowledge of the number of potential suppliers?")
D4	=IF(OR(AND(C4="No",B4="Is there a preferred source?"), AND(C4="No", B4=" Do you have knowledge of the number of potential suppliers?")), "Multiple Quotations", " ")

 

[Fluff]

You have an space before " Do you..." in the formula that shouldn't be there.
You could also simplify the formula like
=IF(C4="no",IF(OR(B4="Is there a preferred source?",B4="Do you have knowledge of the number of potential suppliers?"), "Multiple Quotations", ""),"")

 

[username_rand]

I will check and let you know

Thank you

 

[username_rand]

You have an space before " Do you..." in the formula that shouldn't be there.
You could also simplify the formula like
=IF(C4="no",IF(OR(B4="Is there a preferred source?",B4="Do you have knowledge of the number of potential suppliers?"), "Multiple Quotations", ""),"")

It's not there on my excel worksheet but i will double check now.