Expressions in function arguments

A

Allan

Is there a way to make this statement legal?
=IRR((C5-B5;C6-B6;C7-B7;C8-B8))

It looks like expressions as arguments are not allowed.

";" is used instead of "," due to regional settings.
 
J

Jim Rech

I don't suppose this would be satisfactory?:

=IRR(C5:C8-B5:B8)

--
Jim Rech
Excel MVP
| Is there a way to make this statement legal?
| =IRR((C5-B5;C6-B6;C7-B7;C8-B8))
|
| It looks like expressions as arguments are not allowed.
|
| ";" is used instead of "," due to regional settings.
 
Top