IF And?

[DougStroud]

The following formula is in CF, but is not setup correctly. It is not proving true.

Formula:
=IF(AND(Y38="",X38<>"","Cost?",""))

If Y38 is blank
If X38 is not blank
then Cost?
else blank

thanks

ds

 

[Norie]

doug

You say this is in CF, do you mean conditional formatting?

 

[erik.van.geit]

Hi, Doug,

check out your brackets
AND(Y38="",X38<>"")

kind regards,
Erik

 

[DougStroud]

Yes.... sorry thought that was the standard defacto abbreviation

 

[R_Stephens]

HI DougStroud,

also if you are trying to return Cost if the x and y values are true you need to close the AND bracket first.

=IF(AND(Y38="",X38<>""),"Cost?","")

Hope it helps

Richard

 

[shippey121]

looks like you have a braket in the wrong place

try

=IF(AND(Y38="",X38<>""),"Cost?","")

 

[DougStroud]

Hi Erik,
long time since I have chatted w/ you.

I had that particular formula working. But I wanted to add the condition IF, I am unable to see how this is to work.

 

[erik.van.geit]

CF: =AND(Y38="",X38<>"")

 

[Norie]

doug

In the formula you posted you seem to want to return either Cost? or "".

Now that might work in CF, but probably won't.

When using formulas in CF Excel excepts either a TRUE or FALSE value.

Try Erik's formula.

 

[DougStroud]

Thanks Norie. No it does not work in CF, you are correct.

Erik-- as I wrote previously, I had the same formula you showed me already. I wanted to add the IF. But as Norie pointed out, this is not correct.

Thanks both of you

Doug