Hi,
I get this error in this row in vba...
WS2.Cells(i, 112) = "=IF(AV" & i & "=" & "Null"",20,IF(AV" & i & "*1000" & " < DA" & i & "*CH" & i & ",0,IF(AV" & i & "*1000" & ">DB" & i & "*CH" & i & ",20,20 * (AV" & i & "*1000" & "-DA" & i & "*CH" & i & ")/(DB" & i & "*CH" & i & "-DA" & i & "*CH" & i & ")))"
the original formula in excel is :
=IF(AV2="NULL",20,IF(AV2*1000< DA2*CH2,0,IF(AV2*1000>DB2*CH2,20,20*(AV2*1000-DA2*CH2)/(DB2*CH2-DA2*CH2))))
I'm sitting on it hours can't understand where is the problem
who can help me please?
BR
I get this error in this row in vba...
WS2.Cells(i, 112) = "=IF(AV" & i & "=" & "Null"",20,IF(AV" & i & "*1000" & " < DA" & i & "*CH" & i & ",0,IF(AV" & i & "*1000" & ">DB" & i & "*CH" & i & ",20,20 * (AV" & i & "*1000" & "-DA" & i & "*CH" & i & ")/(DB" & i & "*CH" & i & "-DA" & i & "*CH" & i & ")))"
the original formula in excel is :
=IF(AV2="NULL",20,IF(AV2*1000< DA2*CH2,0,IF(AV2*1000>DB2*CH2,20,20*(AV2*1000-DA2*CH2)/(DB2*CH2-DA2*CH2))))
I'm sitting on it hours can't understand where is the problem
who can help me please?
BR
Last edited by a moderator: