Advertisements

This is a general question based not on specific formula – but I couldn’t find an answer to it anywhere – but it seems like it should be possible.

In this screenshot, you, Y and X are the same for the sake of example (there is a slight difference, but for example’s sake – let’s assume it’s the same).

In the formula, the same formula is used in an if statement to determine if we should move forward with actually calculating the formula. Is there a way to use lambda not to repeat the formula?

### >Solution :

yes you may condense it to something in the sorts of:

```
=lambda(X,if(X>0,X,0))(*FORMULA*)
```

a generalized example in the screenshot: