ExcelBanter - Function problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Function problem (https://www.excelbanter.com/excel-discussion-misc-queries/139570-function-problem.html)

Function problem

The following does not seem to work:

=IF(A10 & B1<"",A1,"")

Is this syntax incorrect?

Pete_UK

Function problem

I think this is what you are trying to do:

=IF(AND(A10,B1<""),A1,"")

Hope this helps.

Pete

On Apr 19, 3:24 pm, "PE" wrote:
The following does not seem to work:

=IF(A10 & B1<"",A1,"")

Is this syntax incorrect?

Starguy

Function problem

=IF(and(A10,B1<""),A1,"")

"PE" wrote:

The following does not seem to work:

=IF(A10 & B1<"",A1,"")

Is this syntax incorrect?

All times are GMT +1. The time now is 08:02 PM.