Formula Referencing the Result of an IRR Calc

[Gray]

Hello All,

Here's the problem I'm running into.

I am using the IRR formula to calculate an IRR value.
This works fine, however, when I create another formula
in a different cell to evaluate the IRR result against
another cell that has a %threshold. If the IRR is higher
than this threshold it should performa a calculation. If
the IRR is lower is should return a zero.

Here is the an example of the formula, where A1 is the
IRR formula result and B1 is the threshold.
=if(A1>=B1,5*5,0)

Thanks in Advance,
Gray

 

[Dave Ramage]

Gray,

I think we need more information to solve your problem.
For a start, WHAT IS THE PROBLEM?

Cheers,
Dave.