IF(OR I think??

[destined_for_clarity]

Hi all,

I've tried searching but I'm not entirely sure what I'm searching for so I didn't find what I'm looking at achieving.

I want a formula that does this:

If B2="Yes" then display the value in cell J10, but if B2="FALSE" then display the value in cell J11.

I know this is basic level stuff but I just can't get it to work.

Any help is greatly appreciated.

Thanks

[Paul]

Should be a nested IF function, like so:

Please Login or Register  to view this content.

B2=Yes results in J10, B2="FALSE" in J11, and anything else will result in a blank result.

[destined_for_clarity]

Thanks Paul that's a great help.

Although it seems to only work where B2=Yes. False just gives a blank cell.
I'm guessing this is due to the formula in cell B2.

Please Login or Register  to view this content.

The B2 formula doesn't work as intended because where the criteria is not met, it states "FALSE" rather than the intended "No".
Do you have any suggestions on how to fix this, only if this is causing your formula not to fully function?

Thanks.

[Limor_OP]

Hi
can you upload a sample file for example?

[XLent]

perhaps:

B2: =IF(COUNTIFS($G$2:$G$5,"<"&$A3,$H$2:$H$5,">"&$A3),"Yes","No")

then

=IF(B2="Yes",J10,J11)

[davsth]

It depends on your FALSE if it was the text FALSE the above works, if it was the result of a formula returning TRUE or FALSE

=IF(B2="Yes",J10,IF(B2="FALSE",J11,""))

remove the "

if you put =b2=FALSE in another cell
and =b2="FALSE" in another cell

which one is true when B" is false

After that is it is if you have included blank spaces in your descriptions


Or you have missed a comma between yes and no at the end of the formula

Please Login or Register  to view this content.

"Yes""No" should be "Yes","No"

[destined_for_clarity]

Thanks mate. This one worked!