“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Develop and enter the appropriate Excel formulas to calculate: the initial amount invested in each stock, the profit (or loss) when you sold the shares of that firm, and Return on Investment (ROI). D. For the entire portfolio: (1 pts) i. Enter Excel formulas to calculate Total Amt Invested, Total Gain Amt (or Total Loss Amt) and Total ROI of the entire portfolio. (Hint: Total ROI is not sum of individual ROIs. To compute the Total ROI on the entire portfolio, use the total profit (or total loss) on the portfolio and the total amount invested.)

Solved by T. H. in 22 mins

I need help calulating ROI and general revision.

Solved by A. E. in 21 mins

I need to make an IF function formula on excel for a Grade Calculator project and was wondering how do I set up a formula with an IF function so that a grade cannot exceed 100%(note that the format of this cell is percentage)

Solved by I. J. in 13 mins

I need help to create an excel calculator formula for settlement payment

Solved by F. W. in 30 mins

I have created a formula with true and false however would like it to be $0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)

Solved by O. E. in 12 mins