Python (preview) in excel
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
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 Read More