unable to record ???

[shadow12345]

Hi,


I am trying to record myself entering this formula into celll an2 of my OPS TRACKER SHEET but it just keeps saying unable to record ? any ideas or any way I can just amend my code ?


=IF(AL2=0,"With Tol & details match",IF(AL2<VLOOKUP(AM2,'Tol List'!$A$1:$C$10,2)&AL2<VLOOKUP(AM2,'Tol List'!$A$1:$C$10,3),"Within Tol & Details Match","total cash dif is " & (ROUND('Ops Tracker Sheet'!AL2,2))&" " & 'Ops Tracker Sheet'!AM2))

 

[erik.van.geit]

Hi, shadow,
don't know if i can help for sure, but your formula is not displaying entirely
use the code-button to avoid some "<" and ">" signs being interpreted as htmltags
=IF(AND(A2<B2,B3>C3),"yes","no")
should be

=IF(AND(A2<B2,B3>C3),"yes","no")

or use spaces
=IF(AND(A2 < B2,B3 > C3),"yes","no")

kind regards,
Erik