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

I am trying to figure out the formula to use that would take the net price (column B) multiply it by 1.285 and then replace the final two digits with ".95". I want every list price to end in .95, but

Solved by B. Q. in 29 mins

I am new to excel. I would like to know how to properly use it. Is there any course at all i can take? I must learn by july 2017

Solved by O. C. in 17 mins

i have numerical data in a cell but when I center it goes to ### and the $ goes to the left hand side
I want to center it

Solved by G. U. in 25 mins

I need to upload a file and am having problems, it should take ten minutes.

Solved by O. H. in 13 mins

I want to create a sort of If-then formula. Im tracking truck capacitys
if truck #16 is filled to the top, its capacity is 15.7 CY. we have over 200 trucks which means over 1000 loads a day. I dont want to have to manually enter the information every night.
I want to make excel recognize that if i put truck 14, i want the next column to say 15.4 CY
and so on

Solved by V. L. in 20 mins

I have a column with ratio values (e.g 130/80). Can I switch it to two different columns with each number in different cell (i.130/80 --> 130 80

Solved by I. U. in 12 mins

I need help with vlookup and addition nest formulas.

Solved by E. U. in 19 mins

Hi, I am using Excel on a Mac and am very new to macros. I want to create lists of data from multiple sheets. For example, each sheet has a customer name in A2 and I want another sheet that lists all customer names, and the same with invoice numbers, invoice dates and more.
The sheets are exactly the same format.

Solved by T. W. in 30 mins

i am trying to create a worksheet that will take 5-10 accounts with various number values. I would like to get all the accounts to the same basis points of exposure ( ex. take every acct down to 25%). So if i were to take an amount to subtract from all accounts until they are all the same percentage exposure.

Solved by T. H. in 13 mins

I am looking to use the IF function to show a value from a cell in sheet 1 (named - MASTER) if the number in sheet 2 (named LOG) equals a certain number. There are multiple options, ranging 1 through to 18 so there will be 18 different potential results but i can't make it pull the value from the cell just to simply show the cell name "Master.E7" for example.

Solved by G. C. in 11 mins