On Jan 2, 9:19*pm, nobuhle sibusiso
wrote:
I have the formula entered as followed: *=XIRR(C2:E2,C1:E1)
where c2-e2 are the values and c1-e1 are the dates viewed in
mm/dd/yy format. *All I get is the #NUM! error in that field.

Did you read the Help page to see if you are violating any of the
rules that cause #NUM?

*How do I fix this problem? *Also, I was reading that here on the
forum that there must be a negative number. *If so, won't this
affect my outcome?

Can I infer from your question that you do not have at least one cash
flow with a negative value and at least one cash flow with a positive
value?

If that is true, that is probably the cause of your #NUM error.

It would be helpful to know what you "cash flows" represent. It would
also be helpful to know what the dates -- especially, whether or not
they are regular in frequency. It is very possible that you do not
need to use XIRR at all.

Since you have only 5 value/date combinations, I suggest that you post
them along with whay they "cash flows" represent.