Hi

I Would like to know if it is possible to do something like this using IF:

From this:
=IF(A1*A2100;A1*A2;0)

To something like this:
=IF(A1*A2100;ResultFromTest;0)

Where "ResultFromTest" variable will be the result from the test "A1*A2", this way removing code redundancy.

Imagine how much a formula like this would be simplified:
From:
=IF(100-((A1*A2+(A3/A4))*A5/100)45;100-((A1*A2+(A3/A4))*A5/100);0)
To:
=IF(100-((A1*A2+(A3/A4))*A5/100)45;testResult;0)


Thanks