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

I need to input a formula in cell B12to compute the loan amount by subtracting the down payment from the purchase price. The formula will need to be an =IF function since the down payment can be stated as either a dollar amount or percentage. If the down payment is a percentage, you will need to convert that percentage into a dollar amount

Solved by I. L. in 26 mins

I need a formula to divide a dollar amount by a number of months and then roundup the answer to the nearest dollar.

Solved by V. J. in 21 mins

How do I delete "$" from a dollar amount, such as $11,600 in excel then carry it through the entire column of cells?

Solved by B. H. in 18 mins

I need to format all numbers representing dollar amounts for commas and zero decimal places and add a dollar sign to the first number in each colum totals

Solved by A. A. in 22 mins

I need to do a conditional format highlighting in Microsoft Excel. G2 to G11 is dollar amounts. I need to highlight them if they are 5% greater than the dollar amount in J1. I tried "=G2>J1+(J1*0.05)" However, it is highlighting cells that are not 5% greater. Please help.

Solved by T. L. in 23 mins