Excel Formula error

excel
activities

#1

formula Hi Guyz…
i want to apply this excel formula on write cell activity…and its showing me an error…if i run this same formula on excel sheet it is working but here its showing an error…can anyone know how to fix this error.

Thanxx


#2

Use this “=IF(C3>$BG$1,”“Ok”","“Defaulter”")"


#3

excel not working


#4

What is the error that you get or the value being populated? Can you paste your workflow here for better understanding?


#5

Can you try like this?

"=IF" & "(C3>$BG$1,”“Ok”","“Defaulter”")

Looks like compiler is picking it up as vb.net inline if and freaking out.


#6

No its not working…its showing an error that “End of statement expected”.


#7

Can you tell me in if condition i need to compare from time so its showing an error that cannot convert double string so how can i pass hours in if condition.


#8

image

Perfectly working.
image

keep Write Cell activity inside the Excel scope.
hope this helps.