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

definition of a function after finding it

  • May 18, 2016
  • 1 reply
  • 1018 views

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.

Best answer by LucMeekes

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

1 reply

LucMeekes23-Emerald IVAnswer
23-Emerald IV
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