Eroor in if formula

[harshab6]

Hi,
why is this if formula showing as #VALUE!
=IF(LEFT(FNDWRR!A7,4)="Cost",OFFSET(FNDWRR!A7,5,1,1,1),""),IF(OFFSET(FNDWRR!A7,5,1,1,1)="","",FNDWRR!B13)
<TABLE style="WIDTH: 92pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=122 border=0><COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 92pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=middle width=122 height=20></TD></TR></TBODY></TABLE>
Regards
harsha

 

[Gerald Higgins]

What is in A7 ?
What is in B13 ?
What is in OFFSET(A7,5,1,1,1) ?

It's possible that the value in one of those cells is giving you your problem.