unable to record ???

shadow12345

Well-known Member
Joined
May 10, 2004
Messages
1,238
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))
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
Code:
=IF(AND(A2<B2,B3>C3),"yes","no")
or use spaces
=IF(AND(A2 < B2,B3 > C3),"yes","no")

kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,118,909
Messages
5,574,986
Members
412,630
Latest member
Eireangel
Top