I would like to write a formula =if("LE@Composant PDU 44<4>. Assembly"="",0, "LE@Composant PDU 44<4>. Assembly") if the variable "LE@Composant PDU 44<4>. Assembly" is no longer present, for it assigned 0 in other computes.
Hello
in sw if is written IIF.
may the force be with you.
1 Like
Hello@Bruno
Generally speaking on the forum
[ IFF ] I am in the title
--Then I put a succinct thing like "PB on formula writing"
When y go to "body of the text" I write the details of the request as you did.
[End / IF ]
But it's not a big deal in the end, so we're still sorry Zen! ;-) ;-)
Kind regards
PS: A short title makes it easier to find similar topics and therefore to help other colleagues ;-)
2 Likes
DSL first forum request.
IIF('x"="",0mm,"x") the variable x is not always present, and I end up with nothing. I wanted to assign 0 in case this happens.
Hello
I don't understand what you want to do,
IIF('x"="",0mm,"x") gives if x = nothing x = 0 otherwise x =>in plain English if x = nothing (implying 0 I imagine) = 0 otherwise 0 ?????
Can you give more info.
may the force be with you.
Sorry for not being clear
IIF('x"="",0mm,"x") gives if x = nothing(no value, that's my problem) x =0 otherwise x = (but if x has a value you have to take it)
v1.png
I confirm if x= no value it's not possible.
I take the example of an Ø. so if my,Ø = nothing necessarily means an Ø 0 so I don't have a hole.cqfd.
may the force be with you.
1 Like
I opened a triquet, or see if the hot line finds me a solus
OK think about putting their solution here.
may the force be with you.
1 Like
I have to get around the problem by going through excel,
I remove all my formulas and I start again in Excel.
the Force my quity...