Get instant live expert help on I need help with excel dollar function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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