Python (preview) in excel

Copper Contributor

How do I get the result of an if statement into the cell where I've selected the python script to display the result?

 

I've so far used this script, it only displays in the diagnostic preview pane

 

 

 

 

a = xl("A1")
if a == xl("L1"):
     print("That's a match")

 

 

 

I want to display this in cell A2

6 Replies

@lynxtra 

print only put information into the right message pane.

Into the grid last variable is returned. In your case it could be

image.png

Don't forget to return value, not object (see '123' ).

Since you have no else, if no match error will be returned

@SergeiBaklan  I kind of know that, but I'm asking if there's a way to put the result into the cell I put the python code

@lynxtra 

If Python code is in cell A2 result of the code will be returned in A2, no other options.

I don't know if you've read my post right

@lynxtra 

Let me try again.

How do I get the result of an if statement into the cell where I've selected the python script to display the result

Python script is in cell A2, result shall be show in the same cell, correct?

Here is the starting point

image.png

I prefer Python editor

image.png

but for simple case we may continue in cell. Code is

image.png

Ctrl+Enter, we have Python object with result preview

image.png

To return the value select "123 Excel Value"  from drop-down in formula bar

image.png

Actually the same was in first sample, but using editor.

Oh now I get you, thanks, now it works

 

I just needed the code that you gave as in

 

a = xl(....