Restraining the size of formulas

[johnnic]

If I wish to increment a formula by a certain amount, based on the result of the formula itself, is there an easier way of doing it than by: FORMULA + FORMULA + X ?

For example, a VERY shortened formula such as =A1+A2+A3 + IF(A1+A2+A3=100,1,0)

 

[johnnic]

Or to put it another way, at the moment I am writing:

=Blah, blah, blah, blah, blah + if(Blah, blah, blah,blah, blah)=1,5,0)

What I would like to do is write something like:

=Blah, blah, blah, blah, blah + if(ANSWER)=1,5,0)

Any thoughts?

 

[shg]

With some very minor simplification, I think that's all you can do:

=A1+A2+A3 + number*(A1+A2+A3=100)

 

[johnnic]

Thanks shg, I expected that might be the case. It seems as though it would be a pretty simple function for Microsoft to add to Excel and might be useful to some. It would certainly be useful to me; I much prefer to use the KISS principle if at all possible.

 

[shg]

It would not be a minor change.