Can we eliminate repetitive input in a formula?

[rwsrws12]

Hi,

I frequently wind up writing the same formula at least twice in the same cell and would love to stop doing it.


Example: =If([some long formula]>0,[the same long formula],[the same long formula -1]).


It would be handy if we could do something like:

=If([a = some long formula]>0, a, a-1) where 'a' is the long formula's result.

Possible?

Obviously, this can be done with an intermediate helper cell, but that is often clumsy.

Thanks

 

[jason]

Helper column or possibly with vba are my only ideas... but i dont know VBA well enough to suggest anything

 

[Hui]

Rwsrws12


Can you post a sample for us to see?


it is often quite possible to simplify the logic

so instead of

=If(C3>0,C3,C3-1)

the following works just as well

=C3-(C3>0)

But only has the formula c3 in twice instead of 3 times


You may also want to consider if the formula has parts of it or can itself be replaced with a Named Formula. These can be used to simplify and make clearer


As I said earlier posting a sample file would be great if you can

 

[NARAYANK991]

Hi Hui ,


I think you meant :


=C3-(C3<=0)


Narayan

 

[Hui]

Absolutely


Grrr...

 

[Debraj]

I think... OP wants to store a data in a veriable..

without assigning its datatype...

Scope of this veriable within that CELL.

And then wants to use the same as many time he wants..


Regards,

Deb

 

[Debraj]

By the way.. If above is correct assumption.. then I hope.. you also want to avoid NAME MANAGER..