Skip to main content
jzy1-Visitor
1-Visitor
May 18, 2016
Solved

definition of a function after finding it

hey lads, attached is my picture again. I cant post the sheet due to certain calculations. And my main problem is that I am using global assignment for definition as I needed to show a summary of checks from the back of the sheet at the front page.

My main problem is if I could global assign the angle that I used the FIND function to calculate. The blue highlighted area are the parts where I have to manually input the angle. I want to global assign so that the next user does not need to manually insert the angle.

LucMeekesAnswer
23-Emerald V
May 18, 2016

It is possible, but then more items need to be defined globally. Here it is:

Now, with lambda globally defined, you can use it anywhere on the sheet.

Success!
Luc

View in thread

1 reply

LucMeekes23-Emerald VAnswer
23-Emerald V
May 18, 2016

It is possible, but then more items need to be defined globally. Here it is:

Now, with lambda globally defined, you can use it anywhere on the sheet.

Success!
Luc

Translate
Terms & ConditionsAccessibility statement