Search found 2 matches

Go to advanced search

by dbvl
Thu Sep 19, 2019 5:58 pm
Forum: PlanMaker 2018 for Windows
Topic: Are there such things as variables within a formula?
Replies: 2
Views: 3818

Re: Are there such things as variables within a formula?

Hi

Thanks

That sounds like it would work.
by dbvl
Wed Sep 18, 2019 8:43 am
Forum: PlanMaker 2018 for Windows
Topic: Are there such things as variables within a formula?
Replies: 2
Views: 3818

Are there such things as variables within a formula?

I hate repeating functions, particularly in formulas. Is there any way that I can avoid something like:

=IF( VLOOKUP(A1, B:B, 1, 0) > 10, VLOOKUP(A1, B:B, 1, 0) - 10, VLOOKUP(A1, B:B, 1, 0) )

[The above is just a simple example of the problem, and not a particular formula that I'm working with.]

Go to advanced search