 # 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