cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

definition of a function after finding it

jzy
1-Newbie
1-Newbie

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.

1 ACCEPTED SOLUTION

Accepted Solutions
LucMeekes
23-Emerald III
(To:jzy)

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 solution in original post

1 REPLY 1
LucMeekes
23-Emerald III
(To:jzy)

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

Top Tags