I am having trouble with an excel problem. I have to use the IRR formula for 4 cells in a row but for some reason I keep getting an error(NUM!).
I am using =IRR(C27:G27) for a formula. Each number is $116,000.00 Do I need to change the numbers to General instead of Currency or do I need some negative numbers.