Formula

[Mark Devoto]

I want to show a value of 1 in L4 by using the IF function as seen below, this works if i type 24 into K4 but if i copy and paste from another Excel book or import as CSV file as text the formula does not work, realy confused can any one help please?

<TABLE style="WIDTH: 124pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=166 border=0 x:str><COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=107 height=22>K</TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=59>L</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" height=22> </TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num x:fmla='=IF(A2="24",1,0)'>=IF(K4="24",1,0)</TD></TR></TBODY></TABLE>

 

[VoG]

Try removing the quotes

=IF(K4=24,1,0)

 

[Mark Devoto]

Thank you works a treat, not sure why i had the quotes their, what do they mean when used?

 

[Peter_SSs]

or possibly
=--(K4=24)

 

[VoG]

Quotes mean text as in

=IF(K4="OK",1,0)

 

[Mark Devoto]

Yes i understand now when i originally wrote the formula it was =IF(K4="BP",1,0) but i have changed the coding we use from alphabetical to numerical, thank you again