Expressions in function arguments

  • Thread starter Thread starter Allan
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
summing values from adjacent column with refrence from adjacent column 6
Excel Formula Help 5
conditional sum? 2
repost: conditional sum? 5
insert new row and copy formula 1
How to determine the value? 2
How do I find data excluded from a list in excel? 2

Back
Top