formula editor
formula editor
(OP)
Is there a way to have an "if" statement in the formula editor? I have an equation that is in excel and looks like this:
=IF((18<(0.2*150)),((495*SQRT((0.2*18)/150))+36),((150*(18/150))+105))
I am trying to incorporate this into Catia V5. Any ideas?
Thanks in advance for the help
=IF((18<(0.2*150)),((495*SQRT((0.2*18)/150))+36),((150*(18/150))+105))
I am trying to incorporate this into Catia V5. Any ideas?
Thanks in advance for the help





RE: formula editor
I was trying to use IF/THEN or CASE statements, and here is the thread I started with some good replies and suggestions:
h
In the end I didn't end up finding an elegant solution with our current license.
--Jay
RE: formula editor
Is it a format unique to Excel?
=IF((18<(0.2*150)),((495*SQRT((0.2*18)/150))+36),((150*(18/150))+105))
Please clarify how this is suppose to look
Thxs
Nev
RE: formula editor
RE: formula editor
--Jay
RE: formula editor
So what would be the formula in the programming world?
Regards
Nev
RE: formula editor
X =((495*SQRT((0.2*Offset_From_End)/Taper_Length))+36)
else
X =((Taper_Length*(Offset_From_End/Taper_Length))+105))
end if
Sort of VB-ish syntax. for catia knowledgeware drop the then & the end if and surround the X = with {} brackets.
RE: formula editor